Fall 2023 COB 191 Assignment 1
docx
keyboard_arrow_up
School
James Madison University *
*We aren’t endorsed by this school
Course
191
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by AdmiralField5381
COB 191 –Business Analytics I – Fall 2023 Assignment 1 Due: Tuesday 09/12/2023 11:59 PM ET Question 1
Consumer Reports evaluates products for consumers. The table below contains the consumer
reports for 15 compact sports utility vehicles (SUVs) from the 2018 model line. a)
How many variables are in the data set? 5
b)
Which of the variables are categorical, and which are quantitative? miles per gallon, acceleration are quantitative and overall score, recommended, owner
satisfaction overall are categorical.
c)
What percentage of these 15 vehicles are recommended? 46%
d)
What percentage of these 15 vehicles have overall miles per gallon of 25 or lower? 73%
e)
What is the average of the acceleration (0-60) sec across all 15 vehicles? 9.31 sec
Question 2
TripAdvisor is one of many online websites that provides ratings for hotels throughout the
world. Ratings provided by 500 guests at the Hyatt Place Harrisonburg can be found in the
HotelRatings sheet. Possible responses were Excellent, Very Good, Average, Poor, and
Terrible. a)
Construct a frequency distribution. b)
Construct a percent frequency distribution. c)
Construct a bar chart for the percent frequency distribution. Average
Excellent Poor
Terrible
Very Good
0
50
100
150
200
250
Count of Rating
d)
Comment on how guests rate their stay at the Hyatt Place Hotel. 82 people said it was average, 141 said it was excellent, 47 said it was poor, 32 said it was terrible, and 198 said it was very good.
Question 3
Nielsen Media Research provided the list of the 25 top-rated single shows in television history.
NetworkShows sheet shows the television network that produced each of these 25 top-rated shows.
a)
Construct a frequency distribution, percent frequency distribution, pie chart and bar chart for
the data.
ABC
CBS
FOX
NBC
0
1
2
3
4
5
6
7
8
9
10
Count of Network
Total
ABC
CBS
FOX
NBC
b)
Which networks have done the best in terms of presenting top-rated television shows? Compare the performance of ABC, CBS, and NBC.
NBC and CBS present and equal amount of 8 while ABC is presents 6
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