2023W2 - Assignment 3_ COMM 191 201 202 2023W2 Application of Statistics in Business
pdf
keyboard_arrow_up
School
University of British Columbia *
*We aren’t endorsed by this school
Course
191
Subject
Communications
Date
Apr 3, 2024
Type
Pages
12
Uploaded by CorporalJellyfishMaster1054
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
1/12
2023W2 - Assignment 3
Due Jan 31 at 11:59p.m.
Points 50
Questions 26
Available Jan 24 at 7a.m. - Jan 31 at 11:59p.m.
Time Limit None
This quiz was locked Jan 31 at 11:59p.m..
Attempt History
Attempt
Time
Score
LATEST
Attempt 1
5,682 minutes
49 out of 50
Score for this quiz: 49 out of 50
Submitted Jan 30 at 8:29p.m.
This attempt took 5,682 minutes.
Question 1
3 / 3 pts
Data Spreadsheet for Assignment 3:
Assignment_3_Datasets_2023W2.xlsx (https://canvas.ubc.ca/courses/129798/files/30060861?
wrap=1) (https://canvas.ubc.ca/courses/129798/files/30060861/download?download_frd=1)
Canadian CEOs: Questions 1 through 18.
Read the Mini Case Study Project on p. 100 of the textbook for background information. Refer to the
Excel data file (
Assignment_3_Datasets_2023W2.xlsx
(https://canvas.ubc.ca/courses/129798/files/30060861?wrap=1) (https://canvas.ubc.ca/courses/129798/files/30060861/download?download_frd=1) ). The spreadsheet
CanadianCEO
lists the total compensation package paid to the top 100 Canadian CEOs in 2010. The spreadsheet units are “
millions of dollars
”; use these units for all graphs and calculations that
follow.
Prepare a histogram of the full set of 100 compensations; use class intervals (i.e. bins) of width 4 (
0-4, 4-
8
, etc.) Make sure to start the horizontal axis at 0.
1. How many of the bars have non-zero height?
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
2/12
Answer 1:
Correct! 6
Correct!
6
Correct Answer
5
Answer 2:
Correct! 51
Correct!
51
Question 2
3 / 3 pts
Correct!
Approximately symmetric but slightly skewed to the right
Strongly skewed to the right
Approximately symmetric but slightly skewed to the left
Strongly skewed to the left
Correct!
Extreme outlier(s)
Correct!
Big gaps in the data
Multiple modes
A unicorn
Question 3
0 / 1 pts
Your Answer:
6
2. What is the Frequency of the highest bar?
Your Answer:
51
Which of these terms describes what you see in the histogram?
(Select all correct answers.)
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
3/12
You Answered
8,384
8.384 (with margin: 0)
Between 8.38 and 8.39
Question 4
1 / 1 pts
Correct!
6.195
6.195 (with margin: 0)
Between 6.19 and 6.2
Question 5
1 / 1 pts
Correct!
3.892
3.892 (with margin: 0)
Between 3.89 and 3.9
Question 6
1 / 1 pts
In this question and the nine following ones (Questions 3 through 12) you will compute summary
statistics using the Canadian CEO
data.
IMPORTANT: Report each value to EXACTLY three decimal places
. e.g. 8.88 should be reported as
8.880.
The mean
is:
Continuing with the previous question, the SD
is: Report to EXACTLY three decimal places
.
Continuing with the previous question, the Min
is: Report to EXACTLY three decimal places
.
Continuing with the previous question, the Q1
is:
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
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
4/12
Correct!
5.242
5.242 (with margin: 0)
Between 5.24 and 5.25
Question 7
1 / 1 pts
Correct!
7.168
7.168 (with margin: 0)
Between 7.16 and 7.17
Question 8
1 / 1 pts
Correct!
9.931
9.931 (with margin: 0)
Between 9.93 and 9.94
Question 9
1 / 1 pts
Correct!
(Use the Excel function QUARTILE.INC)
Report to EXACTLY three decimal places
. Continuing with the previous question, the Median
is: Report to EXACTLY three decimal places
.
Continuing with the previous question, the Q3
is: (Use the Excel function QUARTILE.INC)
Report to EXACTLY three decimal places
.
Continuing with the previous question, the Max
is: Report to EXACTLY three decimal places
.
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
5/12
61.811
61.811 (with margin: 0)
Between 61.81 and 61.82
Question 10
1 / 1 pts
Correct!
4.689
4.689 (with margin: 0)
Between 4.68 and 4.69
Question 11
1 / 1 pts
Correct!
-1.791
-1.791 (with margin: 0)
0 (with margin: 0)
Between -1.8 and -1.79
Question 12
1 / 1 pts
Correct!
16.963
16.963 (with margin: 0)
Between 16.9 and 17
Continuing with the previous question, the IQR
is: Report to EXACTLY three decimal places
.
Continuing with the previous question, the Lower Inner Fence
is: Report to EXACTLY three decimal places
.
Continuing with the previous question, the Upper inner fence
is: Report to EXACTLY three decimal places
.
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
6/12
Question 13
3 / 3 pts
Correct!
Approximately symmetric, but slightly or somewhat skewed to the right
Strongly skewed to the right
Approximately symmetric, but slightly or somewhat skewed to the left
Strongly skewed to the left
Extreme outlier(s)
Big gaps
Multiple modes
Happy faces
Question 14
0.5 / 0.5 pts
Correct!
7.845
7.845 (with margin: 0)
Between 7.84 and 7.85
Question 15
1 / 1 pts
Correct!
Remove the largest value and prepare another histogram. Use class intervals of width 2 (i.e. $2 million).
Which of these terms describes what you see in the histogram?
With the largest value removed, recompute four of the summary statistics: mean, SD, median and IQR
(Questions 14 through 17).
IMPORTANT: Report each value to EXACTLY three decimal places
. e.g. 8.88 should be reported
as 8.880.
The mean
is:
With the largest value removed, the SD
is:
Report to EXACTLY three decimal places
.
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
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
7/12
3.058
3.058 (with margin: 0)
Between 3.05 and 3.06
Question 16
1 / 1 pts
Correct!
7.048
7.048 (with margin: 0)
Between 7.04 and 7.05
Question 17
1 / 1 pts
Correct!
4.679
4.679 (with margin: 0)
4.678 (with margin: 0)
Between 4.67 and 4.68
Question 18
1 / 1 pts
Correct!
0
0 (with margin: 0)
Question 19
4 / 4 pts
With the largest value removed, the Median
is:
Report to EXACTLY three decimal places
.
With the largest value removed, the IQR
is:
Report to EXACTLY three decimal places
.
With the largest value removed, how many outliers are there in the remaining data?
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
8/12
Answer 1:
Approximately symmetric
Skewed to the left
Correct!
Skewed to the right
Uniform
Bimodal
It's complicated
Answer 2:
Correct!
Approximately symmetric
Skewed to the left
Skewed to the right
Uniform
Bimodal
It's complicated
Question 20
2.5 / 2.5 pts
Refer to the Excel data file (
Assignment_3_Datasets_2023W2.xlsx
(https://canvas.ubc.ca/courses/129798/files/30060861?wrap=1) (https://canvas.ubc.ca/courses/129798/files/30060861/download?download_frd=1) ). The pay for the top
500 US CEOs (as compiled by Forbes
magazine) is presented in the spreadsheet USCEO
. The last
three values of 0.000 are correct; those CEOs only received a token salary (but one would presume they
received other forms of compensation). Prepare a histogram. What shape does this histogram have?
Your Answer:
Skewed to the right
Find the natural logarithm (using the Excel function =LN) of the 500 US CEO salaries. Exclude the three
values of 0.000 (since the logarithm is undefined for them) and prepare a histogram of these
transformed data values. What shape does this histogram of the transformed data have?
Your Answer:
Approximately symmetric
Interpreting/Misinterpreting Correlation
The following table shows the mileage of an automobile as the speed increases:
Speed [miles per hour]
20
30
40
50
60
MPG [miles per gallon]
24
28
30
28
24
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
9/12
Correct!
0
0 (with margin: 0)
Question 21
2.5 / 2.5 pts
Correct!
Speed and mileage have a nonlinear relationship.
The dataset is too small.
There is a clear outlier.
The range of values is too small.
Question 22
7.5 / 7.5 pts
Use Excel to compute the correlation. What is the correlation between speed and mileage?
(Report your answer with up to two decimal places.)
Why is the correlation in the previous question so low even though there is a strong relationship between
speed and mileage? You can draw a scatterplot to help you determine the answer, but don't submit it.
(Select the best correct answer.)
Decide whether each of the following statements is reasonable or not. If not, choose the best
explanation:
There is a high correlation between the age of Canadian workers and their occupation...
Not reasonable: correlation must be between two quantitative variables
We found a high correlation (r = 1.09) between students' ratings of faculty teaching and ratings made
by other faculty members...
Not reasonable: the value of r is impossible.
The correlation between planting rate and yield of corn was found to be 0.23 bushels per year...
Not reasonable: there should be no units.
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
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
10/12
Answer 1:
Statement is reasonable.
Not reasonable: planting rate and yield are time series data.
Not reasonable: the value of r is impossible.
Not reasonable: correlation cannot be between two categorical variables.
Not reasonable: there wouldn't be enough data to reach this conclusion.
Not reasonable: there should be no units.
Not reasonable: there is likely an outlier.
Correct!
Not reasonable: correlation must be between two quantitative variables
Not reasonable: the distribution is skewed.
Not reasonable, but none of the above choices are correct.
Answer 2:
Statement is reasonable.
Not reasonable: planting rate and yield are time series data.
Correct!
Not reasonable: the value of r is impossible.
Not reasonable: correlation cannot be between two categorical variables.
Not reasonable: there wouldn't be enough data to reach this conclusion.
Not reasonable: there should be no units.
Not reasonable: there is likely an outlier.
Not reasonable: correlation must be between two quantitative variables
Not reasonable: the distribution is skewed.
Not reasonable, but none of the above choices are correct.
Answer 3:
Statement is reasonable.
Not reasonable: planting rate and yield are time series data.
Not reasonable: the value of r is impossible.
Not reasonable: correlation cannot be between two categorical variables.
Not reasonable: there wouldn't be enough data to reach this conclusion.
Correct!
Not reasonable: there should be no units.
Not reasonable: there is likely an outlier.
Not reasonable: correlation must be between two quantitative variables
Not reasonable: the distribution is skewed.
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
11/12
Not reasonable, but none of the above choices are correct.
Question 23
2.5 / 2.5 pts
Correct!
A high R
does not necessarily mean the linear model is appropriate.
The data are not linear.
A strong linear relationship does not mean there is a strong association.
The variables should be switched so that Advertising
is the response variable
Question 24
2.5 / 2.5 pts
Correct!
93% is the fraction of variation accounted for by the model, not a percentage of Sales
.
Again, the data are not linear.
A high R
does not necessarily mean the linear model is appropriate.
The variables should be switched: Sales
determine 93% of Advertising
.
Question 25
2.5 / 2.5 pts
Correct!
The model can help us predict but we can't know with certainty.
Again, the data are not linear.
An advertising agent who created a regression model using amount spent on Advertising
to predict
annual Sales
for a company made several statements. Assuming the calculations were done correctly,
what is wrong with the following statement?
"My R
of 93% shows that this linear model is appropriate."
2
2 Continuing from the previous question, what is wrong with the following statement?
"The amount spent on Advertising
determines 93% of the annual Sales
for a company."
2
And finally, what is wrong with the following statement?
"If this company spends $1.5 million on advertising, then the annual sales will be $10 million."
3/24/24, 10:41 AM
2023W2 - Assignment 3: COMM 191 201 202 2023W2 Application of Statistics in Business
https://canvas.ubc.ca/courses/129798/quizzes/676555
12/12
Regression can't be used with time-series data in this way.
The variables should be switched: Sales
can be used to predict Advertising
.
Question 26
2.5 / 2.5 pts
Yes, smaller hospitals means shorter stays
Yes, shorter stays require smaller hospitals
No; big hospitals have more beds so patients can stay longer
Correct!
No; smaller hospitals are less likely to treat serious illnesses requiring longer stays
Quiz Score: 49 out of 50
A study shows that there is a positive correlation between the size of a hospital (measured by its number
of beds) and the median number of days that the patients remain in the hospital. Does this mean that
you can shorten a hospital stay by choosing a small hospital?
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