Scenario:

Food Service Quality of Dining Facility at Riverside University: In addition to the survey data, university administrators provided enrollment statistics of the students for this semester. There are 10,000 students currently enrolled with 55% of them male students. A fairly equal number of students are freshman, sophomore, junior, and senior. Dining facility statistics show that almost 40% of their student customer are freshman, 25% are sophomore, 20% are junior, and 15% are senior. They have almost same number of male and female customers.

Use Mean and Standard deviation functions in EXCEL to complete table given. There are two functions in Excel to compute standard deviation, choose appropriate one.

Q4) Overall satisfaction and retention are measured on a 5-point scale. Using Excel, compute mean and standard deviation for these variables for overall, those who visit dining facility daily and those who don't visit dining facility daily (remaining all categories of frequency of visit) and format it as shown in the table below. (Please explain excel steps and formulas to use)

Frequency Of Visit	Satisfaction	Retention
Mean	Standard Deviation	Mean	Standard Deviation
Daily
Not Daily
Total

survey data, and variables and scale of measurement table is below.

Table 1: Variables and Scale of Measurement:

Variable	Survey Question	Scale of Measurement
D1	How often do you eat at/purchase meals?	1- Daily 2- 2 or 3 times a week 3- Weekly 4- 2 or 3 times per month 5- Once a month or less
D2	Gender	1-Male 2-Female
D3	Year in School	1-Freshman 2-Sophomore 3-Junior 4-Senior
Q1	Survey ID	Number from 1 through 62
Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15	Attractive food presentation Variety of food choices Availability of healthy food options Taste and flavor of food Portion size Hot food is hot and cold food is cold Quality of ingredients Cleanliness of the facility Friendliness of service staff Speed of service Hours of service Prices Value of the meal Overall satisfaction with facility	Questions Q2 through Q14 were measured on following scale: 1- very unsatisfied 2- somewhat unsatisfied 3- neither unsatisfied not satisfied 4- somewhat satisfied 5- very satisfied
Q16	If a new option became available on campus for meals would you stay with this facility or go with the new option? (retention)	Questions Q15 -Q16 measured on following scale: 1- very likely stay with this facility 2- somewhat likely stay with this facility 3- neither likely nor unlikely 4- somewhat unlikely stay with this facility 5- very unlikely stay with this facility

Survey Data from excel:

Q1	D1	D2	D3	Q2	Q3	Q4	Q5	Q6	Q7	Q8	Q9	Q10	Q11	Q12	Q13	Q14	Q15	Q16
1	5	2	1	4	3	5	4	5	4	4	5	5	5	5	3	4	4	1
2	4	1	1	4	4	3	4	4	4	4	4	5	5	5	4	5	4	2
3	1	2	2	4	3	3	3	3	3	4	4	5	3	3	3	3	3	1
4	1	2	1	5	4	3	4	4	5	5	5	5	4	5	5	5	5	1
5	1	1	1	3	3	5	3	2	4	3	4	5	4	4	3	3	4	3
6	4	2	4	4	4	3	3	3	3	3	5	3	2	3	3	3	3	4
7	1	2	1	3	2	3	3	3	4	3	3	4	3	4	2	3	4	3
8	4	1	1	3	4	4	3	3	3	3	4	4	3	3	2	2	3	3
9	5	1	1	4	4	4	5	3	4	5	4	4	3	4	4	4	4	3
10	3	2	1	5	4	3	4	5	4	4	4	5	5	4	3	4	4	3
11	5	1	3	2	3	3	2	4	4	2	4	3	3	4	2	2	3	4
12	3	2	1	3	2	3	4	4	4	3	5	3	2	1	3	3	3	5
13	5	1	3	4	5	4	5	4	5	4	4	5	4	4	3	3	4	3
14	1	2	1	1	1	1	1	2	1	3	3	4	2	1	2	2	1	5
15	5	1	4	3	4	5	3	2	4	4	5	5	5	4	3	2	5	3
16	1	1	2	2	3	3	2	2	4	2	4	4	3	3	3	2	2	4
17	4	1	4	2	3	2	2	4	3	2	4	4	4	4	1	2	3	2
18	5	1	3	4	5	4	3	3	4	5	5	5	5	3	2	1	3	3
19	3	1	1	4	5	2	4	3	4	4	5	5	4	4	2	3	4	3
20	1	1	4	3	3	3	3	4	1	2	2	4	4	3	2	1	1	3
21	1	1	3	4	4	4	4	2	4	4	5	4	3	1	4	3	3	4
22	1	2	2	2	2	2	1	2	1	2	2	2	1	2	2	2	2	4
23	1	1	2	3	4	4	4	4	3	2	3	3	4	2	5	3	3	4
24	5	1	2	2	1	1	2	2	3	2	4	4	4	3	2	2	2	3
25	2	1	3	4	4	5	3	3	5	4	5	2	2	1	1	2	3	3
26	5	1	2	4	3	2	3	3	3	2	5	4	3	2	1	3	3	4
27	2	1	2	4	3	3	4	1	5	3	5	3	1	3	2	2	3	4
28	1	1	2	1	1	1	3	1	2	2	5	2	1	5	2	3	1	1
29	1	1	2	3	2	1	2	1	5	3	5	3	3	4	1	2	2	5
30	3	1	4	4	4	3	4	4	5	3	5	5	4	4	3	4	4	3
31	5	2	4	3	2	2	3	3	4	3	4	4	4	3	1	3	3	2
32	3	1	4	3	1	2	4	3	4	4	4	4	3	1	4	2	3	3
33	2	1	4	3	2	4	4	3	3	3	4	4	4	5	3	5	4	3
34	3	1	4	4	3	4	5	4	5	5	5	5	4	4	3	4	4	3
35	1	1	3	4	4	3	4	5	2	4	3	3	1	1	4	4	4	3
36	1	2	3	3	5	5	5	3	5	5	5	5	3	1	2	3	4	3
37	1	1	2	5	3	4	4	3	4	4	5	5	3	1	3	3	4	3
38	2	1	2	3	2	3	2	4	3	3	4	5	4	4	4	3	3	2
39	1	1	3	3	4	2	2	4	2	3	4	5	3	3	1	2	3	3
40	3	1	4	3	1	1	5	4	5	4	5	5	4	1	2	2	2	5
41	1	2	2	3	3	4	4	3	5	3	3	3	3	2	3	3	3	3
42	5	1	2	4	3	2	2	3	3	2	4	4	4	3	3	4	3	2
43	1	1	4	4	3	3	4	4	4	3	3	4	2	4	5	5	4	3
44	1	1	3	3	3	5	3	5	5	4	5	4	4	2	5	4	4	3
45	1	1	4	3	1	3	3	2	2	2	5	5	3	3	4	3	3	3
46	2	1	4	3	4	3	4	2	2	2	4	5	5	5	3	2	2	4
47	2	1	3	3	2	2	3	2	3	4	3	5	3	4	1	3	3	3
48	3	2	2	4	3	5	5	4	3	5	4	5	5	5	3	5	4	3
49	5	1	3	4	4	5	4	3	4	4	5	5	5	2	2	3	5	2
50	1	2	4	3	4	4	3	5	3	3	4	5	3	3	4	4	4	3
51	2	1	1	4	4	5	4	3	5	3	5	5	5	4	1	3	4	3
52	2	2	4	4	5	5	4	4	5	5	4	5	5	5	5	5	5	2
53	2	1	2	4	2	2	4	4	5	2	5	3	4	2	1	4	3	1
54	5	2	1	3	4	2	3	3	3	3	4	4	3	3	2	3	3	3
55	1	2	1	3	2	2	3	4	5	3	4	5	5	4	3	4	3	3
56	5	1	1	5	5	3	4	5	5	5	5	5	5	1	1	2	3	5
57	5	1	2	4	4	3	3	4	4	4	4	5	5	5	3	3	4	3
58	3	2	3	4	4	4	4	1	4	4	4	4	4	4	1	3	3	1
59	2	1	2	3	2	1	4	2	3	2	3	4	3	3	4	5	4	3
60	1	1	4	2	1	3	3	2	3	3	3	3	3	1	2	2	2	3
61	1	2	2	3	3	2	5	4	5	3	5	5	4	2	3	3	3	3
62	1	1	3	3	1	2	3	4	4	3	5	5	3	2	3	4	2	1