Statistics For Decision Making W5 *Excel*
LUUP777
Week5ExerciseRequirementPost.xlsxRegression Analysis
| CUSTOMERS IN PAST 6 MONTHS | ||
| Customer # | # Visits | $ Purchases |
| 1 | 7 | 450 |
| 2 | 6 | 395 |
| 3 | 6 | 470 |
| 4 | 2 | 210 |
| 5 | 10 | 550 |
| 6 | 4 | 345 |
| 7 | 6 | 345 |
| 8 | 3 | 210 |
| 9 | 4 | 293 |
| 10 | 1 | 119 |
| 11 | 3 | 211 |
| 12 | 9 | 479 |
| 13 | 7 | 430 |
| 14 | 7 | 405 |
| 15 | 6 | 359 |
| 16 | 10 | 544 |
| 17 | 9 | 522 |
| 18 | 5 | 327 |
| 19 | 6 | 353 |
| 20 | 7 | 405 |
| 21 | 4 | 289 |
| 22 | 7 | 386 |
| 23 | 7 | 403 |
| 24 | 2 | 215 |
| 25 | 7 | 416 |
| 26 | 9 | 485 |
| 27 | 3 | 333 |
| 28 | 7 | 255 |
| 29 | 2 | 391 |
| 30 | 6 | 268 |
Generate a scatter plot, the correlation coefficient and the linear equation that evaluates whether a relationship exists between the number of times a customer visited the store in the past 6 months and the total amount of money the customer spent. Complete the five step hypothesis test to evaluate the strength of the relationship between the two variables (test for possibility the slope can go to zero). Complete all five steps of the hypothesis testing process for the slope. Use a level of significance of .05. Predict the amount a customer will spend if they visit the store 5 times.
T test
| Week # | Weekly Sales($) - Rep A | Weekly Sales($) - Rep B |
| 1 | 4600 | 5600 |
| 2 | 6200 | 3000 |
| 3 | 3565 | 2550 |
| 4 | 5235 | 4750 |
| 5 | 4350 | 3740 |
| 6 | 2552 | 2315 |
| 7 | 6950 | 1957 |
| 8 | 7844 | 1629 |
| 9 | 6898 | 2416 |
| 10 | 4200 | 2500 |
| 11 | 6884 | 4237 |
| 12 | 4007 | 6322 |
| 13 | 7214 | 3725 |
| 14 | 2358 | 5890 |
| 15 | 7745 | 5119 |
| 16 | 1337 | 5184 |
| 17 | 1052 | 3439 |
| 18 | 6052 | 4828 |
| 19 | 1495 | 3667 |
| 20 | 3530 | 3518 |
| 21 | 4749 | 6073 |
| 22 | 3833 | 5566 |
| 23 | 7869 | 4555 |
| 24 | 4541 | 5867 |
| 25 | 6882 | 6039 |
| 26 | 3868 | 1032 |
| 27 | 5934 | 4834 |
| 28 | 4447 | 3687 |
| 29 | 5504 | 5500 |
| 30 | 5554 | 4659 |
You want to determine whether there is a statistically different average weekly sales between Sales Rep A and Sales Rep B. Create Null and Alternative Hypothesis statements that would allow you to determine whether or not their sales performance is statistically different. Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of the two candidates. Complete all five steps of the process.
Chi Square Test
| Observed | Expected |
| 10 | 6.2 |
| 23 | 20 |
| 39 | 47.782 |
| 40 | 47.55 |
| 27 | 20.026 |
| 3 | 3.2 |
A real estate company is analyzing the selling prices of residential homes in a given community. 140 homes that have been sold in the past month are randomly selected and their selling prices recorded. The statistician working on the project has stated that in order to perform various statistical tests, the data must be distributed according to a normal distribution. In order to determine whether the selling prices of homes included in the random sample are normally distributed, the statistician divides the data into 6 classes of equal size and records the number of observations in each class. She then performs a chi-square goodness-of-fit test for normal distribution. The results are summarized in the table. Complete the five step hypothesis Chi Square Goodness of fit test at level of significance 0.05.
