Question

Open a MS Word and type all of your answers on this page. Please make sure to write down the question number when giving the answers. Don't forget to write your name, today's date and section. 1. Elizabeth Lunch Grape Soda (g) Taco Salad(g) Pizza (g) Menu Item Carbohydrate Protein Saturated Fat Polyunsatured fat Monounsaturated 41.7 26.6 39.8 17.4 20.2 6.0 4.4 1.5 2.4 4.5 6.2 Fat 0.028 0.055 Cholesterol a. Construct a bar graph using menu items on x axis and pizza and taco salad on the y axis. Make sure to include title. Label Axis. b. Construct a double-y graph, with menu items on the x-axis and Y1 Pizza, Y2 Taco Salad c. Construct a column graph with menu item on the x axis and pizza on y axis. d. Generate statistics data for both pizza and Taco Salad. e. In a new column calculate the average grams intake between the pizza and Taco salad f. In a new column calculate Pizza * 25% g. In a new column calculate Taco Salad * 75% h. In a new column calculate Pizza*25% + Taco Salad*75%

Answer 1

Menu Item	Pizza(g)	Taco Salad(g)	Grape Soda(g)
Carbohydrate	39.8	26.6	41.7
Protein	20.2	17.4	0
Saturated Fat	4.4	6	0
Polyunsaturated Fat	2.4	1.5	0
Monounsaturated Fat	6.2	4.5	0
Cholesterol	0.028	0.055	0

a) Horizontal Bar graph with Menu Item on x-axis and Pizza and Taco Salad on y-axis

To add label select graph->layout->Axis-Titles and then select horizontal and vertical axis title

Cholesterol Monounsaturated fat Polyunsaturated fat X-Axis Saturated fat Taco Salad(g) Pizza(g) Protein Carbohydrate 0 10 20 30 40 50 Y-Axis

b) Double y graph

10 20 30 40 50 Y-Axis Pizza(g) Taco Salad(g) Protein Cholesterol Carbohydrate Saturated fat Polyunsaturated fat Monounsaturated fat X-Axis

c) Column graph with Menu item on X-axis and Pizza on Y-axis

to add pizza only on y axis right click on graph->select data-> click on taco salad and click on remove same for Grape Soda

Pizza(g) Y-Axis mohonano Pizza(g) Protein Saturated fat Carbohydrate Monounsaturated fat Cholesterol Polyunsaturated fat X-Axis

d) statistics data

if you want to find sum,count you can do directly from table

1)select Data tab and in Analysis group select Data Analysis
2)Select Descriptive Statistics then click OK
3)Select the Input Range for which you want to generate statistics data
4)Select cell as the Output Range
5)checked Summary statistics

example

Pizza(g)		Taco Salad(g)
Sum	73.028	Sum	56.055
Count	6	Count	6

e) average grams Pizza and Taco Salad

Average Pizza		Average Taco Salad
12.1713		9.3425

f) Pizza*25%

Pizza(g)	Pizza*25%
39.8	9.95
20.2	5.05
4.4	1.1
2.4	0.6
6.2	1.55
0.028	0.007

g)Taco Salad*75%

Taco Salad(g)	Taco salad*75%
26.6	19.95
17.4	13.05
6	4.5
1.5	1.125
4.5	3.375
0.055	0.04125

h) Pizza*25%+Taco Salad*75%

Pizza(g)	Taco Salad(g)	Pizza*25%	Taco salad*75%	Pizza*25%+Taco Salad*75%
39.8	26.6	9.95	19.95	29.9
20.2	17.4	5.05	13.05	18.1
4.4	6	1.1	4.5	5.6
2.4	1.5	0.6	1.125	1.725
6.2	4.5	1.55	3.375	4.925
0.028	0.055	0.007	0.04125	0.04825