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