Question
1. Draw histograms of five category sales (Chocolate, DVD, Magazine, Soda, Hot dogs) using 10 bins for each chart. (2 points for each; Total 10points)
2. Report Descriptive Stats of the five variables using Data Analysis tools. Then, connected to the histogram on the above question 1, describe the distribution of each variable including central tendency and the shape of distribution (e.g., right or left skewed, or symmetric, etc). (2 points for each; total 10 points)
3. Draw a scatter plot between hot dog sales and soda sales. Assuming that there is a positive relationship between the two category sales, draw a 'linear' trend line over the scatter chart and show the equation over the chart using the trendline options. Describe the relationship between the two category sales including the meaning. (10 points)
4. Draw a time-series chart of the total sales of five categories over 30 weeks (Note: you need to get the sum of five category sales for each week using the 'sum' function). Put a linear trendline over the chart and the equation of the line. Describe the trend of the sales whether the sales is increasing or decreasing over the weeks or where you see fluctuations of the sales. Explain what the slope on the equation means in this chart. (20 points)
Week | Chocolate | DVDS | Magazines | Soda | Hot Dogs |
1 | 857 | $5,820 | $3,374 | $3,036 | $2,564 |
2 | 1,050 | $8,656 | $3,821 | $3,589 | $2,615 |
3 | 863 | $6,749 | $2,857 | $3,279 | $2,512 |
4 | 933 | $5,580 | $3,284 | $3,981 | $2,705 |
5 | 905 | $8,534 | $3,923 | $3,411 | $2,386 |
6 | 901 | $6,837 | $3,837 | $3,484 | $2,977 |
7 | 597 | $7,794 | $2,713 | $3,498 | $2,946 |
8 | 1,185 | $8,708 | $3,375 | $3,169 | $2,729 |
9 | 565 | $8,892 | $3,674 | $3,660 | $2,977 |
10 | 964 | $6,338 | $2,640 | $3,797 | $2,322 |
11 | 982 | $7,258 | $2,926 | $3,201 | $2,939 |
12 | 658 | $5,468 | $2,360 | $3,738 | $2,648 |
13 | 961 | $8,690 | $3,466 | $3,374 | $2,619 |
14 | 691 | $7,054 | $2,888 | $3,371 | $2,449 |
15 | 695 | $8,988 | $2,433 | $3,211 | $2,589 |
16 | 1,065 | $5,658 | $2,085 | $3,622 | $2,919 |
17 | 851 | $6,781 | $3,392 | $3,812 | $2,533 |
18 | 636 | $5,423 | $3,714 | $3,458 | $2,590 |
19 | 989 | $7,763 | $2,534 | $3,101 | $2,596 |
20 | 1,102 | $5,893 | $2,456 | $3,687 | $2,581 |
21 | 811 | $8,391 | $3,308 | $3,771 | $2,376 |
22 | 766 | $5,631 | $3,009 | $3,641 | $2,341 |
23 | 777 | $8,995 | $2,395 | $3,627 | $2,667 |
24 | 625 | $5,864 | $2,430 | $3,303 | $2,410 |
25 | 560 | $8,927 | $3,065 | $3,574 | $2,107 |
26 | 970 | $7,615 | $3,716 | $3,704 | $2,623 |
27 | 888 | $5,373 | $3,800 | $3,424 | $2,098 |
28 | 525 | $5,845 | $3,164 | $3,624 | $2,793 |
29 | 675 | $5,986 | $3,241 | $3,117 | $2,235 |
30 | 1,113 | $8,049 | $3,925 | $3,611 | $2,865 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started