A marketing professor at Givens College is int course last quarter follow.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Topic Video
Question

The second slide is the first part of the question  and the first slide is the second part of the question

A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the
course last quarter follow.
Hours
Total
Spent Studying
Points Earned
45
40
30
35
90
75
60
65
105
90
65
50
90
90
80
80
55
45
75
65
(a) Develop an estimated regression equation showing how total points earned can be predicted from hours spent studying. (Round your numerical values to two decimal places.)
Transcribed Image Text:A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the course last quarter follow. Hours Total Spent Studying Points Earned 45 40 30 35 90 75 60 65 105 90 65 50 90 90 80 80 55 45 75 65 (a) Develop an estimated regression equation showing how total points earned can be predicted from hours spent studying. (Round your numerical values to two decimal places.)
(b) Test the significance of the model with a = 0.05. (Use the Ftest.)
State the null and alternative hypotheses.
O Ho: P1= 0
H B, +o
O Hg: B1 0
B, z o
1.
O Ho: Po+0
H Po= 0
७ H,: B, + 0
H B1-0
O Ho: Bo = 0
H Bo# 0
%3D
Find the value of the test statistic. (Round your answer to two decimal places.)
Find the p-value. (Round your answer to three decimal places.)
p-value =
ww.
State your conclusion.
O Do not reject H,. We conclude that the relationship between hours spent studying and total points earned is significant.
Reject H. We cannot conclude that the relationship between hours spent studying and total points earned is significant.
O Do not reject H,. We cannot conclude that the relationship between hours spent studying and total points earned is significant.
O Reject H, We conclude that the relationship between hours spent studying and total points earned is significant.
:(c) Predict the total points earned by Mark Sweeney. He spent 85 hours studying. (Round your answer to two decimal places.)
points
(d) Develop a 95% prediction interval for the total points earned by Mark Sweeney. (Round your answers to two decimal places.)
points to
points
Transcribed Image Text:(b) Test the significance of the model with a = 0.05. (Use the Ftest.) State the null and alternative hypotheses. O Ho: P1= 0 H B, +o O Hg: B1 0 B, z o 1. O Ho: Po+0 H Po= 0 ७ H,: B, + 0 H B1-0 O Ho: Bo = 0 H Bo# 0 %3D Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value = ww. State your conclusion. O Do not reject H,. We conclude that the relationship between hours spent studying and total points earned is significant. Reject H. We cannot conclude that the relationship between hours spent studying and total points earned is significant. O Do not reject H,. We cannot conclude that the relationship between hours spent studying and total points earned is significant. O Reject H, We conclude that the relationship between hours spent studying and total points earned is significant. :(c) Predict the total points earned by Mark Sweeney. He spent 85 hours studying. (Round your answer to two decimal places.) points (d) Develop a 95% prediction interval for the total points earned by Mark Sweeney. (Round your answers to two decimal places.) points to points
Expert Solution
Step 1

Note:

Hi there! Thank you for posting the question. As your question has more than 3 parts, we have solved only the first three subparts for you. If you need any specific subpart to be answered, please re-submit the question by specifying the subpart number or name.

Step 2

(a). Develop an estimated regression equation showing how total points earned can be predicted from hours spend studying:

Simple linear regression model:

A simple linear regression model is given as y^ = b0 + bx + e  where y^ is the predicted value of response variable, and x be the predictor variable. The quantity b is the estimated slope corresponding to x and b0 is the estimated intercept of the line, from the sample data.

Given data represents the values of the variables x = Hours spent studying and y = Total points earned for a sample of 10 students.

EXCEL software can be used to obtain the simple regression equation.

Software Procedure:

Step-by-step software procedure to perform a simple linear regression model using EXCEL software is as follows:

  • Open an EXCEL file.
  • Enter the data of Total points earned in columns A and name it as Total points earned.
  • Enter the data of Hours spent studying in column B and name them as Hours spent studying.
  • Go to Data > Data Analysis > Regression.
  • Enter Input Y Range as $A$1:$A$11, enter Input X Range as $B$1:$B$11.
  • Select Labels, Confidence Level and enter the confidence level as 95%.
  • Click OK.

The output is:

Statistics homework question answer, step 2, image 1

From the obtained regression output, the estimated slope corresponding to the predictor variable “X = Hours spent studying” is b = 0.83 and the estimated intercept of the line is b0 = 5.85.

The estimated regression equation showing how total points earned can be predicted from hours spend studying is Total points earned = 5.85 + 0.83*Hours spent studying.

Thus, the regression equation is Y^ = 5.85 + 0.83*X.

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Application of Algebra
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman