Statistics ANOVA

Sheet1

Tues Wed Thu Fri Mon Tues Wed Thu Fri Mon Tues Wed Thu Fri Mon
199.95 195.74 102.68 162.88 101.76 20 13 23 13 13 41 33 34 27 20
186.94 120.18 228.78 88.02 119.57 33 15 27 12 19 23 32 31 30 27
172.31 137.65 197.56 70 97 33 20 29 14 17 30 27 26 24 18
181.43 125.57 180.63 75.87 150.51 31 24 31 15 26 22 21 28 23 31
177.41 153.84 205.36 118.54 138.04 39 24 35 11 25 29 48 25 31 25
236.01 149.58 206.17 93.1 151.91 36 33 37 22 36 35 33 35 16 24
217.29 148.24 168.08 77.52 130.77 54 34 43 14.5 24 20 11 21 10 8
164.54 121.41 127.93 61.94 128.59 48 35 33 24 30 8 4 4 3 5
159.23 148.08 164.86 74.13 82.96 50 45 50 26 26 6 4 13 4 16
240.87 151.52 150.99 55 42 45 14 10 11
(Data for A) Total Sales Dollars by Day of Week (Data for B) Number of Sodas Sold by Day of Week (Data for C) Number of Coffees Sold by Day of Week
Bonus Project 3:
The Executive Express managers wish to know if there is a difference in sales between various days of the week. In particular, they would like to know:
A) If the (population) mean Total Sales is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
B) If the (population) mean Number of Sodas Sold is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
C) If the (population) mean Number of Coffees Sold is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
Instructions: To Complete this project, paste the results of your analyses (e.g. tables from StatCrunch) and answers to these questions in a Word document.
1) State which statistical procedure studied in this course allows you to compare the means of five different groups
2) Address the manager’s question regarding Total Sales (A).
Copy the data from Excel to StatCrunch
Run the appropriate analysis
Answer the questions:
Is there evidence that the mean Total Sales varies among the 5 weekdays?
If so, which means appear to be significantly higher or lower than which others?
Estimate the difference in Total Sales between two days that show statistically significant differences in means,
or state why an estimated difference is not meaningful and therefore not reported
3) Address the manager’s question regarding Number of Sodas Sold (B).
Copy the data from Excel to StatCrunch
Run the appropriate analysis
Answer the questions:
Is there evidence that the mean Number of Sodas sold varies among the 5 weekdays?
If so, which means appear to be significantly higher or lower than which others?
Estimate the difference in Number of Sodas Sold between two days that show statistically significant differences in means,
or state why an estimated difference is not meaningful and therefore not reported
4) Address the manager’s question regarding Number of Coffees Sold (C).
Copy the data from Excel to StatCrunch
Run the appropriate analysis
Answer the questions:
Is there evidence that the mean Number of Coffees sold varies among the 5 weekdays?
If so, which means appear to be significantly higher or lower than which others?
Estimate the difference in Number of Coffees Sold between two days that show statistically significant differences in means,
or state why an estimated difference is not meaningful and therefore not reported
5) Write one or two sentences that make recommendations to the manager based on the results of your analyses.
Evaluation: Up to 6 bonus points
Work will be evaluated on correct choice of statistical procedure and correct answers to questions
You may do all or part of the assignment. If only some of the analyses are done, partial points will be assigned as appropriate.

Sheet2

Sheet3

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)