Students in QMB 3600 – Quantitative Methods in Business course decided to research the relationship between the Mid Term Exam, the average number of study hours spent per week during the semester and the final course grade for a given student. A sample of containing data from a previous semester was provided by the instructor and summarized in the following table: Student # Mid-Term Exam Average Number of study hours per week 2.0 Final Course Grade Grade 1 50.0 65.0 60.0 4.0 85.0 55.0 3.5 78.0 85.0 6.0 90.0 55.0 5.0 700 234n

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.2: Representing Data
Problem 22PFA
icon
Related questions
Question
2.
) Students in QMB 3600-Quantitative Methods in Business course decided to research the relationship
between the Mid Term Exam, the average number of study hours spent per week during the semester and the
final course grade for a given student. A sample of containing data from a previous semester was provided by the
instructor and summarized in the following table:
Student #
Mid-Term Exam
Average Number of
Final Course Grade
Grade
study hours per week
50.0
2.0
65.0
2
60.0
4.0
85.0
55.0
3.5
78.0
4
85.0
6.0
90.0
55.0
5.0
70.0
72.0
4.5
89.0
7
75.0
6.5
91.0
8.
45.0
3.0
65.0
9.
88.0
5.5
89.0
10
90.0
7.5
96.0
T Develop a linear regression model, where Y is the Final Grade Course and X is the Mid-Term Exam.
a)
Calculate the coefficient of determination (r²), the coefficient of correlation (r), the variance (o) for the model
and apply Hypothesis Testing to test the significance of the linear model for a 0.05 exactly as demonstrated in
the Triple A Construction Example on page 121 of your textbook. Show all your calculations and follow the same
guidance provided in Problem #1.
Plot a scatter diagram for the data used in topic (a) and plot the linear regression model as well. Follow
b)
the same guidance provided in Problem #1.
Develop a linear regression model, where Y is the Final Grade Course and X is the Average Number of
c)
Study Hours per week. Calculate the coefficient of determination (r), the coefficient of correlation (r), the variance
(o*) for the model and apply Hypothesis Testing to test the significance of the linear model for a = 0.05 exactly as
demonstrated in the Triple A Construction Example on page 121 of your textbook. Show all your calculations and
follow the same guidance provided in Problem #1.
d)
Plot a scatter diagram for the data used in topic (c) and plot the linear regression model as well. Follow
the same guidance provided in Problem #1.
e)
Based on the coefficient of determination (r') for each linear regression models developed, which of
the two linear regression models should be used to predict the Final Grade in QMB 3600 and explain your decision.
Transcribed Image Text:2. ) Students in QMB 3600-Quantitative Methods in Business course decided to research the relationship between the Mid Term Exam, the average number of study hours spent per week during the semester and the final course grade for a given student. A sample of containing data from a previous semester was provided by the instructor and summarized in the following table: Student # Mid-Term Exam Average Number of Final Course Grade Grade study hours per week 50.0 2.0 65.0 2 60.0 4.0 85.0 55.0 3.5 78.0 4 85.0 6.0 90.0 55.0 5.0 70.0 72.0 4.5 89.0 7 75.0 6.5 91.0 8. 45.0 3.0 65.0 9. 88.0 5.5 89.0 10 90.0 7.5 96.0 T Develop a linear regression model, where Y is the Final Grade Course and X is the Mid-Term Exam. a) Calculate the coefficient of determination (r²), the coefficient of correlation (r), the variance (o) for the model and apply Hypothesis Testing to test the significance of the linear model for a 0.05 exactly as demonstrated in the Triple A Construction Example on page 121 of your textbook. Show all your calculations and follow the same guidance provided in Problem #1. Plot a scatter diagram for the data used in topic (a) and plot the linear regression model as well. Follow b) the same guidance provided in Problem #1. Develop a linear regression model, where Y is the Final Grade Course and X is the Average Number of c) Study Hours per week. Calculate the coefficient of determination (r), the coefficient of correlation (r), the variance (o*) for the model and apply Hypothesis Testing to test the significance of the linear model for a = 0.05 exactly as demonstrated in the Triple A Construction Example on page 121 of your textbook. Show all your calculations and follow the same guidance provided in Problem #1. d) Plot a scatter diagram for the data used in topic (c) and plot the linear regression model as well. Follow the same guidance provided in Problem #1. e) Based on the coefficient of determination (r') for each linear regression models developed, which of the two linear regression models should be used to predict the Final Grade in QMB 3600 and explain your decision.
1.
An air conditioning company located in Central Florida collected data for the number of air
conditioning units sold in the Central Florida area and for the outside temperature on the day that sales took
place. The Sales Manager put the following table together:
Outside Temperature
Sales
(Degrees F)
(Number of air conditioning units sold)
68
72
78
7
81
12
84
15
86
16
89
22
91
18
93
19
94
26
a)
calculated in topic (b). Consider that:
Y: number of air conditioning units sold
X: outside temperature (degrees F)
Guidance: graph should look like the one presented in Figure 4.2 of textbook
lot a scatter diagram for the data provided on the table above and the linear regression line
Perform the linear regression calculation and provide the linear regression equation that describes
b)
the relationship between Y (number of air conditioning units sold) and X (outside temperature in degrees
Fahrenheit.
Guidance: follow the steps presented on Table 4.2 of textbook
Calculate SST, SSE and SSR for this linear regression
c)
Guidance: follow the steps presented on Table 4.3 of textbook
d)
Calculate the coefficient of determination (r?) and the coefficient of correlation (r).
) Using the linear regression equation that you developed in topic (b), calculate the estimated sales for
a day that will reach 84 degrees F and for a day that will reach 94 F and for both temperature levels calculate the
error "e" when comparing the estimated value against the actual data provided. At which of the two
temperatures, is your model more accurate? Explain.
Transcribed Image Text:1. An air conditioning company located in Central Florida collected data for the number of air conditioning units sold in the Central Florida area and for the outside temperature on the day that sales took place. The Sales Manager put the following table together: Outside Temperature Sales (Degrees F) (Number of air conditioning units sold) 68 72 78 7 81 12 84 15 86 16 89 22 91 18 93 19 94 26 a) calculated in topic (b). Consider that: Y: number of air conditioning units sold X: outside temperature (degrees F) Guidance: graph should look like the one presented in Figure 4.2 of textbook lot a scatter diagram for the data provided on the table above and the linear regression line Perform the linear regression calculation and provide the linear regression equation that describes b) the relationship between Y (number of air conditioning units sold) and X (outside temperature in degrees Fahrenheit. Guidance: follow the steps presented on Table 4.2 of textbook Calculate SST, SSE and SSR for this linear regression c) Guidance: follow the steps presented on Table 4.3 of textbook d) Calculate the coefficient of determination (r?) and the coefficient of correlation (r). ) Using the linear regression equation that you developed in topic (b), calculate the estimated sales for a day that will reach 84 degrees F and for a day that will reach 94 F and for both temperature levels calculate the error "e" when comparing the estimated value against the actual data provided. At which of the two temperatures, is your model more accurate? Explain.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning