Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Discuss the connection of statistics to your research. Important points Problem statement Related literature Conceptual framework Levels of measurement Appropriate statistical tool/s XYZ Company, owned
- Discuss the connection of statistics to your research. Important points
- Problem statement
- Related literature
- Conceptual framework
- Levels of measurement
- Appropriate statistical tool/s
- XYZ Company, owned by Mr. Juan, is a new restaurant in Davao City. It is an eat-all-you can restaurant located in Torres Street. Due to the presence of many restaurants and bars in the area, Mr. Juan was worried that his restaurant might not survive the competition. This prompted him to conduct a survey to know which among the 4Ps of marketing his customers prefer. The following are the results of the survey (refer to the dataset below): Based on the survey, provide the following:
- What is the level of measurement of the following:
- Education
- Sex
- Product Quality
- Competitive Price
- Accessibility
- Advertising Capability
- Customer Satisfaction
- Provide the measures of central tendency of the following:
Variables | Mean | Median | Mode |
| |||
| |||
| |||
| |||
|
- Provide the measures of variability of the following:
Variables | Range | Variance | Standard Deviation |
| |||
| |||
| |||
| |||
|
- If Mr. Juan wanted to know if there is a relationship between the variables Product Quality, Competitive Price, Accessibility, and Advertising Capability towards Customer Satisfaction what appropriate statistical tool should be used? Explain
- In relation to question 2d, what is the rvalue between:
- Customer Satisfaction and Product Quality
- Customer Satisfaction and Competitive Price
- Customer Satisfaction and Accessibility
- Customer Satisfaction and Advertising Capability
- In relation to your answer in question 2e, which has the highest relationship toward Customer Satisfaction? Which has the lowest relationship? Explain
Dataset
ID | Education | Sex | Product Quality | Competitive Price | Accessibility | Advertising Capability | Customer Satisfaction |
1 | 2 | 0 | 8.50 | 2.50 | 4.80 | 6.80 | 8.2 |
2 | 3 | 1 | 8.20 | 5.10 | 3.40 | 5.30 | 5.7 |
3 | 3 | 0 | 9.20 | 5.60 | 5.40 | 4.50 | 8.9 |
4 | 1 | 1 | 6.40 | 7.00 | 4.70 | 8.80 | 4.8 |
5 | 2 | 0 | 9.00 | 5.20 | 2.20 | 6.80 | 7.1 |
6 | 1 | 1 | 6.50 | 3.10 | 4.00 | 8.50 | 4.7 |
7 | 1 | 1 | 6.90 | 5.00 | 2.10 | 8.90 | 5.7 |
8 | 2 | 0 | 6.20 | 3.90 | 4.60 | 6.90 | 6.3 |
9 | 2 | 1 | 5.80 | 5.10 | 3.70 | 9.30 | 7 |
10 | 1 | 0 | 6.40 | 5.10 | 4.70 | 8.40 | 5.5 |
11 | 3 | 0 | 8.70 | 4.60 | 2.70 | 6.80 | 7.4 |
12 | 1 | 0 | 6.10 | 6.30 | 4.40 | 8.20 | 6 |
13 | 1 | 1 | 9.50 | 4.60 | 5.00 | 7.60 | 8.4 |
14 | 3 | 1 | 9.20 | 5.70 | 2.40 | 7.10 | 7.6 |
15 | 2 | 0 | 6.30 | 4.70 | 4.50 | 8.80 | 8 |
16 | 3 | 0 | 8.70 | 4.00 | 3.20 | 4.90 | 6.6 |
17 | 2 | 1 | 5.70 | 6.70 | 3.30 | 6.20 | 6.4 |
18 | 2 | 0 | 5.90 | 5.50 | 3.50 | 8.40 | 7.4 |
19 | 2 | 1 | 5.60 | 5.10 | 3.70 | 9.10 | 6.8 |
20 | 3 | 0 | 9.10 | 3.60 | 5.30 | 8.40 | 7.6 |
21 | 1 | 0 | 5.20 | 7.10 | 3.90 | 8.40 | 5.4 |
22 | 3 | 1 | 9.60 | 6.80 | 5.40 | 4.50 | 9.9 |
23 | 2 | 0 | 8.60 | 7.40 | 3.50 | 3.70 | 7 |
24 | 3 | 0 | 9.30 | 2.60 | 2.20 | 6.20 | 8.6 |
25 | 1 | 0 | 6.00 | 5.30 | 3.50 | 8.00 | 4.8 |
26 | 2 | 0 | 6.40 | 6.60 | 4.00 | 7.10 | 6.6 |
27 | 3 | 0 | 8.50 | 7.20 | 4.10 | 4.80 | 6.3 |
28 | 1 | 1 | 7.00 | 5.40 | 2.60 | 9.00 | 5.4 |
29 | 3 | 0 | 8.50 | 5.70 | 2.30 | 4.80 | 6.3 |
30 | 1 | 1 | 7.60 | 3.00 | 5.10 | 7.70 | 5.4 |
31 | 1 | 1 | 6.90 | 8.50 | 4.50 | 5.20 | 6.1 |
32 | 1 | 0 | 8.10 | 7.20 | 2.30 | 6.60 | 6.4 |
33 | 1 | 1 | 6.70 | 6.50 | 5.30 | 9.20 | 5.4 |
34 | 2 | 1 | 8.00 | 6.10 | 5.50 | 8.70 | 7.3 |
35 | 1 | 0 | 6.70 | 5.20 | 3.00 | 8.40 | 6.3 |
36 | 1 | 0 | 8.70 | 6.10 | 3.50 | 5.60 | 5.4 |
37 | 2 | 0 | 9.00 | 5.90 | 3.90 | 6.80 | 7.1 |
38 | 3 | 0 | 9.60 | 6.20 | 2.90 | 7.70 | 8.7 |
39 | 2 | 1 | 8.20 | 3.90 | 5.80 | 9.00 | 7.6 |
40 | 1 | 0 | 6.10 | 3.00 | 5.10 | 8.20 | 6 |
41 | 2 | 1 | 8.30 | 3.30 | 3.10 | 9.10 | 7 |
42 | 2 | 1 | 9.40 | 4.70 | 3.80 | 8.50 | 7.6 |
43 | 3 | 0 | 9.30 | 4.60 | 5.80 | 7.40 | 8.9 |
44 | 2 | 1 | 5.10 | 6.60 | 4.40 | 5.90 | 7.6 |
45 | 3 | 1 | 8.00 | 4.70 | 3.60 | 5.20 | 5.5 |
46 | 2 | 0 | 5.90 | 5.70 | 5.80 | 8.40 | 7.4 |
47 | 3 | 1 | 10.00 | 7.10 | 2.90 | 3.80 | 7.1 |
48 | 2 | 1 | 5.70 | 6.80 | 5.70 | 8.20 | 7.6 |
49 | 3 | 0 | 9.90 | 3.70 | 4.20 | 6.80 | 8.7 |
50 | 3 | 1 | 7.90 | 4.30 | 4.40 | 4.70 | 8.6 |
51 | 1 | 0 | 6.70 | 5.90 | 3.40 | 7.20 | 5.4 |
52 | 3 | 1 | 8.20 | 3.70 | 2.70 | 5.30 | 5.7 |
53 | 3 | 0 | 9.40 | 4.80 | 3.20 | 6.30 | 8.7 |
54 | 1 | 1 | 6.90 | 5.70 | 3.30 | 5.20 | 6.1 |
55 | 2 | 1 | 8.00 | 3.80 | 3.20 | 8.70 | 7.3 |
56 | 3 | 1 | 9.30 | 7.30 | 3.70 | 7.40 | 7.7 |
57 | 2 | 0 | 7.40 | 4.80 | 4.50 | 9.60 | 9 |
58 | 3 | 1 | 7.60 | 5.20 | 5.60 | 4.40 | 8.2 |
59 | 3 | 1 | 10.00 | 5.30 | 4.20 | 3.80 | 7.1 |
60 | 3 | 1 | 9.90 | 7.20 | 2.60 | 5.40 | 7.9 |
61 | 3 | 0 | 8.70 | 8.40 | 2.80 | 4.90 | 6.6 |
62 | 2 | 0 | 8.40 | 6.70 | 4.50 | 6.70 | 8 |
63 | 1 | 0 | 8.80 | 3.80 | 4.30 | 5.80 | 6.3 |
64 | 1 | 0 | 7.70 | 6.30 | 2.40 | 6.20 | 6 |
65 | 1 | 0 | 6.60 | 5.80 | 4.90 | 7.20 | 5.4 |
66 | 2 | 1 | 5.70 | 3.50 | 5.40 | 8.20 | 7.6 |
67 | 2 | 1 | 5.70 | 7.90 | 2.70 | 6.20 | 6.4 |
68 | 2 | 1 | 5.50 | 4.70 | 4.30 | 6.00 | 6.1 |
69 | 1 | 1 | 7.50 | 3.80 | 2.90 | 7.60 | 5.2 |
70 | 2 | 0 | 6.40 | 2.70 | 3.90 | 7.10 | 6.6 |
71 | 3 | 0 | 9.10 | 6.10 | 6.30 | 8.40 | 7.6 |
72 | 1 | 1 | 6.70 | 3.00 | 4.80 | 5.00 | 5.8 |
73 | 2 | 0 | 6.50 | 2.70 | 6.50 | 8.70 | 7.9 |
74 | 3 | 0 | 9.90 | 7.50 | 5.60 | 6.80 | 8.6 |
75 | 2 | 0 | 8.50 | 5.30 | 5.00 | 6.80 | 8.2 |
76 | 3 | 0 | 9.90 | 6.80 | 5.40 | 4.90 | 7.1 |
77 | 1 | 0 | 7.60 | 7.60 | 4.70 | 7.40 | 6.4 |
78 | 2 | 1 | 9.40 | 7.00 | 4.70 | 8.50 | 7.6 |
79 | 3 | 0 | 9.30 | 6.30 | 5.50 | 4.60 | 8.9 |
80 | 1 | 1 | 7.10 | 4.90 | 4.00 | 7.80 | 5.7 |
81 | 3 | 0 | 9.90 | 7.40 | 4.00 | 4.90 | 7.1 |
82 | 3 | 0 | 8.70 | 6.40 | 2.40 | 6.80 | 7.4 |
83 | 2 | 0 | 8.60 | 5.80 | 2.90 | 6.30 | 6.6 |
84 | 1 | 1 | 6.40 | 6.70 | 2.20 | 8.40 | 5 |
85 | 2 | 0 | 7.70 | 6.70 | 1.90 | 5.90 | 8.2 |
86 | 1 | 1 | 7.50 | 4.10 | 3.50 | 7.60 | 5.2 |
87 | 1 | 0 | 5.00 | 1.30 | 3.50 | 8.20 | 5.2 |
88 | 2 | 0 | 7.70 | 8.00 | 3.50 | 5.90 | 8.2 |
89 | 2 | 1 | 9.10 | 5.50 | 4.20 | 8.30 | 7.3 |
90 | 2 | 1 | 5.50 | 7.70 | 5.60 | 6.30 | 8.2 |
91 | 3 | 1 | 9.10 | 7.00 | 4.40 | 7.30 | 7.4 |
92 | 1 | 1 | 7.10 | 4.10 | 2.10 | 9.90 | 4.8 |
93 | 3 | 1 | 9.20 | 4.60 | 4.20 | 7.10 | 7.6 |
94 | 3 | 0 | 9.30 | 5.40 | 4.60 | 4.60 | 8.9 |
95 | 3 | 1 | 9.30 | 4.00 | 4.70 | 7.40 | 7.7 |
96 | 1 | 1 | 8.60 | 5.60 | 2.30 | 6.70 | 7.3 |
97 | 1 | 0 | 7.40 | 2.60 | 4.10 | 7.20 | 6.3 |
98 | 1 | 0 | 8.70 | 3.30 | 3.10 | 5.60 | 5.4 |
99 | 2 | 1 | 7.80 | 5.80 | 5.20 | 7.90 | 6.4 |
100 | 2 | 1 | 7.90 | 4.40 | 5.90 | 9.70 | 6.4 |
Education:
1 = elementary
2 = high school
3 = college
Sex:
1 = male
2 = female
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