Selected States Unemployment Rate Total Sales Persons/ 100,000 Population Sales/ 100,000 Population 1 9.1 235.7 99.6 2 7.9 171.79 83.6 3 9.6 199.94 108.5 4 7.9 211.94 81.3 5 12.5 245.97 156 6 8.9 229.52 62.3 7 9 241.15 99.4 8 8.5 258.81 203.7 9 12 247.31 138.7 10 10.4 284.5 127.7 11 6.3 216.64 77.5 12 9.7 178.47 13.7 13 9.2 277.99 156.3 14 9.5 180.6 95.9 15 6.1 174.52 33.2 16 6.8 269.07 54.1 17 10.3 196.43 86.1 Use MS Excel to Solve: If the Null Hypothesis states that: There is no significant relationship between the Total Sales Persons/100,000 population and Sales/100,000 population Required: 4.1 Use Pearson Product Moment Correlation Analysis for the two variables stated in the null hypothesis and show the resulting correlation coefficient? 4.2 Interpret the meaning of the resulting value? 4.2 Use simple regression analysis to explain the relationship. Do you reject the null hypothesis? Why? 4.3 Is the regression result good? Justify your answer.
Selected States |
Unemployment Rate |
Total Sales Persons/ 100,000 Population |
Sales/ 100,000 Population |
1 |
9.1 |
235.7 |
99.6 |
2 |
7.9 |
171.79 |
83.6 |
3 |
9.6 |
199.94 |
108.5 |
4 |
7.9 |
211.94 |
81.3 |
5 |
12.5 |
245.97 |
156 |
6 |
8.9 |
229.52 |
62.3 |
7 |
9 |
241.15 |
99.4 |
8 |
8.5 |
258.81 |
203.7 |
9 |
12 |
247.31 |
138.7 |
10 |
10.4 |
284.5 |
127.7 |
11 |
6.3 |
216.64 |
77.5 |
12 |
9.7 |
178.47 |
13.7 |
13 |
9.2 |
277.99 |
156.3 |
14 |
9.5 |
180.6 |
95.9 |
15 |
6.1 |
174.52 |
33.2 |
16 |
6.8 |
269.07 |
54.1 |
17 |
10.3 |
196.43 |
86.1 |
Use MS Excel to Solve:
- If the Null Hypothesis states that: There is no significant relationship between the Total Sales Persons/100,000 population and Sales/100,000 population
Required:
4.1 Use Pearson Product Moment
4.2 Interpret the meaning of the resulting value?
4.2 Use simple
4.3 Is the regression result good? Justify your answer.
4.4 What is the resulting regression equation? How much is the predicted change in sales for a unit increase in the Total Sales Persons?
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 2 images