Assignment 3- BUSM5130-Fall2022 (1)

docx

School

Kwantlen Polytechnic University *

*We aren’t endorsed by this school

Course

5130

Subject

Business

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MegaDragonMaster563

BUSM 5130 Assignment #3 Solve the following problem for this assignment. Please complete the required information on the front-page template that I have posted on Moodle and include it in your assignment. Save your Excel file with your name and ID number as the file name. Upload your solution in Moodle. This assignment is due at the beginning of the class next week . 1. Open the Restaurant file on Moodle and answer the following questions: a. What is the mean, median and mode for Meal cost at Metro Area Mean 40.36 Median 40 Mode 25 b. Construct frequency distribution, relative frequency, percent frequency, cumulative frequency, cumulative relative frequency and cumulative percent frequency for this data. Meal Cost Frequency relative frequency percent frequency 10-19 1 0.02 2 19-29 13 0.26 26 30-39 11 0.22 22 40-49 10 0.2 20 50-59 11 0.22 22 60-69 4 0.08 8 Grand Total 50 1 100 Meal Cost Cumulative frequency Cumulative relative frequency Cumulative percent frequency <=19 1 0.02 2 <=29 14 0.28 28

<=39 25 0.5 50 <=49 35 0.7 70 <=59 46 0.92 92 <=69 50 1 100 c. Chart your data in part b (use the right chart for the right tables, as you see fit). 10-19 19-29 30-39 40-49 50-59 60-69 0 2 4 6 8 10 12 14 Histogram of the Meal Cost at Metro Area Meal Cost Frequency 10-19 14% 19-29 23% 30-39 19% 40-49 18% 50-59 19% 60-69 7% Percent frequency of Cost at Metro Area

<=19 <=29 <=39 <=49 <=59 <=69 0 10 20 30 40 50 60 1 14 25 35 46 50 Ogive for Meal Cost at Metro Area d. Develop a stem and leaf diagram. Stem Leaf 1 4 2 1134555666999 3 1113666789 4 1334447789 5 1222334489 6 2368 e. Compare the meal cost at City Centre and Metro Area. Meal Cost at Center City Meal Cost at Metro Area Mean 55.68 Mean 40.36 Standard Error 2.71930963 6 Standard Error 1.90247100 3 Median 56 Median 40 Mode 29 Mode 25 Standard Deviation 19.2284228 4 Standard Deviation 13.4525014 7 Sample Variance 369.732244 9 Sample Variance 180.969795 9 Kurtosis - 0.55018221 Kurtosis - 0.91409157

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4 4 Skewness 0.29277099 6 Skewness 0.16254763 2 Range 77 Range 54 Minimum 22 Minimum 14 Maximum 99 Maximum 68 Sum 2784 Sum 2018 Count 50 Count 50

Assignment 3- BUSM5130-Fall2022 (1)

Related Documents