Question
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
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.
Q1). Based on the sample obtained through survey, hw would I construct a joint probability table in EXCEL for frequency of visit D1 (row) and gender D2 (column)? What formula would I use?
Variables and Scale of Measurement:
Variable | Survey Question | Scale of Measurement |
D1 | How often do you eat at/purchase meals? (Frequency of visit) | 1 - Daily 2 - 2 or 3 times per week 3 - Weekly 4 - 2 or 3 times per month 5 - Once a month or less |
D2 | Gender | 1 - Male 2 - Female |
Q1 | Survey ID | Number from 1 through 62 |
Survey Data:
Q1 | D1 | D2 |
1 | 5 | 2 |
2 | 4 | 1 |
3 | 1 | 2 |
4 | 1 | 2 |
5 | 1 | 1 |
6 | 4 | 2 |
7 | 1 | 2 |
8 | 4 | 1 |
9 | 5 | 1 |
10 | 3 | 2 |
11 | 5 | 1 |
12 | 3 | 2 |
13 | 5 | 1 |
14 | 1 | 2 |
15 | 5 | 1 |
16 | 1 | 1 |
17 | 4 | 1 |
18 | 5 | 1 |
19 | 3 | 1 |
20 | 1 | 1 |
21 | 1 | 1 |
22 | 1 | 2 |
23 | 1 | 1 |
24 | 5 | 1 |
25 | 2 | 1 |
26 | 5 | 1 |
27 | 2 | 1 |
28 | 1 | 1 |
29 | 1 | 1 |
30 | 3 | 1 |
31 | 5 | 2 |
32 | 3 | 1 |
33 | 2 | 1 |
34 | 3 | 1 |
35 | 1 | 1 |
36 | 1 | 2 |
37 | 1 | 1 |
38 | 2 | 1 |
39 | 1 | 1 |
40 | 3 | 1 |
41 | 1 | 2 |
42 | 5 | 1 |
43 | 1 | 1 |
44 | 1 | 1 |
45 | 1 | 1 |
46 | 2 | 1 |
47 | 2 | 1 |
48 | 3 | 2 |
49 | 5 | 1 |
50 | 1 | 2 |
51 | 2 | 1 |
52 | 2 | 2 |
53 | 2 | 1 |
54 | 5 | 2 |
55 | 1 | 2 |
56 | 5 | 1 |
57 | 5 | 1 |
58 | 3 | 2 |
59 | 2 | 1 |
60 | 1 | 1 |
61 | 1 | 2 |
62 | 1 | 1 |
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