Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

USE = 0.05 To determine whether the ACT scores can be used to predict college GPAs, scores and GPAs of 20 students surveyed. The data

USE = 0.05

To determine whether the ACT scores can be used to predict college GPAs, scores and GPAs of 20 students surveyed. The data are shown.

ACT Scores College GPAs
16 1.85
18 2.2
24 2.8
25 3.5
34 4
27 3.18
29 3.9
25 2.9
30 4
21 2.6
17 2.5
21 3.65
28 3.1
31 3.72
35 3.24
18 2.3
17 1.7
26 3.1
28 3.5
23 2.76

USE = 0.05

A) Considering the model where ACT scores are used to predict college GPAs, test the model to determine if the model is valid. Be sure to state your null and alternative hypotheses. What is your p-value? What is your conclusion? As a part of this assignment, submit a copy of your Excel file with this p-value clearly labeled.

B) Using this same model, test the slope to determine if it is significant. Be sure to state your null and alternative hypotheses.What is your p-value? What is your conclusion? As a part of this assignment, submit a copy of your Excel file with this p-value clearly labeled.

C) What is the value of the Coefficient of Determination? As a part of this assignment, submit a copy of your Excel file with this value clearly labeled.

D) What is the value of the standard error of the estimate? As a part of this assignment, submit a copy of your Excel file with this value clearly labeled.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Non-Cooperative Game Theory

Authors: Takako Fujiwara Greve

1st Edition

4431556451, 9784431556459

More Books

Students explore these related Mathematics questions