Answered: A business statistics professor would…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

A business statistics professor would like to develop a regression model to predict the exam scores for students based on their current GPAs, the number of hours they studied for the exam, and the number of times they were absent during the semester. The data for these variables can be found in this file.

a) Run the multiple regression in Excel. Hint: set x₁ = GPA, x₂ = Hours, X₃ = Absences.

b) Find the R² and explain its meaning.

c) Explain the outcome of the F test. What does it mean?

d) Explain the outcomes of the t tests for the slope coefficients.

e) Write out the regression equation.

f) Explain the meanings of the slope coefficients.

37
94
3.26
6.50
38
98
2.88
3.50
39
99
3.73
5.00
1
40
100
3.48
6.50
1
41
100
3.00
7.00
42
43
44
45

A
В
D
1
Score
GPA
Hours
Absences
2
68
2.53
3.00
3
69
2.25
4.00
3
4
70
2.60
2.50
1.
71
3.10
0.50
6.
74
3.08
6.00
4
7
77
2.75
3.50
8
77
3.35
1.50
9
78
2.98
3.00
3
10
78
2.99
2.00
3
11
79
2.84
2.50
12
79
2.80
4.50
13
82
3.44
7.00
1
14
83
3.25
3.00
15
84
3.15
3.00
16
84
3.18
5.50
17
84
2.95
2.00
18
84
2.71
4.00
19
85
3.20
4.50
3
20
85
3.75
2.00
21
85
3.57
3.50
2
22
86
2.92
6.00
1.
23
86
3.04
6.50
1.
24
86
3.16
5.00
25
87
3.89
7.50
4
26
87
3.54
4.00
27
89
3.33
6.50
1.
28
89
3.66
5.00
29
90
2.87
3.50
1.
30
90
3.40
6.00
1.
31
91
3.22
4.50
2.
32
91
3.79
7.00
33
92
3.93
6.00
2
34
92
4.00
5.00
35
92
3.60
6.50
36
93
2.98
4.00
2
37
94
3.26
6.50
38
98
2.88
3.50
2.
C.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

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