For the data given below, fill in the blanks, using Formulas, Descriptive Statistics and Regression outputs. 1) 18th Percentile of X1: Sample Variance of X2: Median of X2: Correlation Between X1 andY: Mean of Y: Y XI X2 2) 3) 4) 33 9. 192 44 11 397 34 10 235 5) 60 13 345 6) Minimum value of X1: 20 245 9) b.: 30 235 7) b. 45 12 296 b: 10) 11) 12) 8) 25 9. 235 SSR: 53 10 295 SSE: 45 13 335 SST: 37 11 243 F Statistics: Adjusted R Square: 13) 44 13 413 14) 15) 16) 35 12 290 MSE: 40 312 MSR: 17) Standard Error of Regression: 18) 19) 20) Standard error of b2: t-value of b1: Fit the regression equation:
For the data given below, fill in the blanks, using Formulas, Descriptive Statistics and Regression outputs. 1) 18th Percentile of X1: Sample Variance of X2: Median of X2: Correlation Between X1 andY: Mean of Y: Y XI X2 2) 3) 4) 33 9. 192 44 11 397 34 10 235 5) 60 13 345 6) Minimum value of X1: 20 245 9) b.: 30 235 7) b. 45 12 296 b: 10) 11) 12) 8) 25 9. 235 SSR: 53 10 295 SSE: 45 13 335 SST: 37 11 243 F Statistics: Adjusted R Square: 13) 44 13 413 14) 15) 16) 35 12 290 MSE: 40 312 MSR: 17) Standard Error of Regression: 18) 19) 20) Standard error of b2: t-value of b1: Fit the regression equation:
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Topic Video
Question
100%
Please help me to answer this question in Exel

Transcribed Image Text:A
B
D E
F
G
H
J
K
L
M
N
Q
R
S
V
1
Use Data Analysis Tool
Descriptive Statistics output
3
4
5
7
For the data given below, fill in the blanks, using Formulas, Descriptive Statistics and Regression outputs.
8
9
1)
Mean of Y:
Y
XI
X2
10
2)
3)
4)
5)
18th Percentile of X1:
33
9
192
Sample Variance of X2:
Median of X2:
Correlation Between X1 and Y:
11
44
11
397
12
34
10
235
13
60
13
345
14
6)
Minimum value of X1:
20
11
245
15
9)
(6
b:
30
7
235
16
7)
b.
45
12
296
17
8)
10)
b:
25
9
235
18
SSR:
53
10
295
19
11)
SSE:
45
13
335
20
Regression output
12)
13)
14)
15)
16)
17)
SST:
F Statistics:
Adjusted R Square:
MSE:
MSR:
Standard Error of Regression:
37
11
243
21
44
13
413
22
35
12
290
23
40
9
312
24
25
26
18)
Standard error of b2:
27
19)
20)
t-value of b1:
28
Fit the regression equation:
29
30
31
32
33
34
35
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 5 images

Knowledge Booster
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.Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman