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

4

Uploaded by MegaDragonMaster563 on coursehero.com

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
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
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS