Question

In: Statistics and Probability

exper score salary 4 78 24 7 100 43 1 86 23.7 5 82 34.3 8...

exper score salary
4 78 24
7 100 43
1 86 23.7
5 82 34.3
8 86 35.8
10 84 38
0 75 22.2
1 80 23.1
6 83 30
6 91 33
9 88 38
2 73 26.6
10 75 36.2

1-R2=

2-F test statistic=

3.b2=

4-P-value for F test=

Solutions

Expert Solution

Output using excel:

Data > Data analysis > Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.935318
R Square 0.874819
Adjusted R Square 0.849783
Standard Error 2.665625
Observations 13
ANOVA
df SS MS F Significance F
Regression 2 496.5675 248.2837 34.94219 3.07E-05
Residual 10 71.05558 7.105558
Total 12 567.6231
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -4.15742 8.895252 -0.46737 0.65025 -23.9773 15.66244 -23.9773 15.66244
exper 1.46519 0.235336 6.22596 9.81E-05 0.94083 1.989551 0.94083 1.989551
score 0.33381 0.111003 3.007215 0.01318 0.08648 0.58114 0.08648 0.58114

1. R2 = R Square = 0.8748

2. F test statistic = 34.9422

3. b2 = slope for score = 0.3338

4. P-value for F test = 0.000031

----------------------------------

if any doubt ask me in comments.


Related Solutions

number of absences 6 2 15 9 12 5 8 final grade 82 86 43 74...
number of absences 6 2 15 9 12 5 8 final grade 82 86 43 74 58 90 65 The data below were obtained in a study on the number of absences and the final grades (in percentages) of seven randomly selected students in a statistics class. Number of absences 6 2 15 9 12 5 8 Final grade 82 86 43 74 58 90 65 (2 4 6 8 10 12 14 5 0 6 0 7 0 8...
int[]array1={67, 78, 92, 45, 67, 86, 24, 96, 39, 82, 86}; String[] array2 ={“Namath”, “Dockery”, “Atkinson”,...
int[]array1={67, 78, 92, 45, 67, 86, 24, 96, 39, 82, 86}; String[] array2 ={“Namath”, “Dockery”, “Atkinson”, “Sauer”, “Brady”, “Maynard”, “Boozer”}; Write code using selection sort to sort array1 in descending order Write code using selection sort to alphabetize array2. Write a method called cubicNumbers that will sum the 3rd power of each of first n positive integers cublic powers . Example cubicNumbers(4)-> 43 + 33+23 +13 =64+27+8+1=100. Write this code in an iterative fashion Write a method called cubicNumbers that...
SALARY EDUC EXPER TIME 39000 12 0 1 40200 10 44 7 42900 12 5 30...
SALARY EDUC EXPER TIME 39000 12 0 1 40200 10 44 7 42900 12 5 30 43800 8 6 7 43800 8 8 6 43800 12 0 7 43800 12 0 10 43800 12 5 6 44400 15 75 2 45000 8 52 3 45000 12 8 19 46200 12 52 3 48000 8 70 20 48000 12 6 23 48000 12 11 12 48000 12 11 17 48000 12 63 22 48000 12 144 24 48000 12 163 12...
SALARY EDUC EXPER TIME 39000 12 0 1 40200 10 44 7 42900 12 5 30...
SALARY EDUC EXPER TIME 39000 12 0 1 40200 10 44 7 42900 12 5 30 43800 8 6 7 43800 8 8 6 43800 12 0 7 43800 12 0 10 43800 12 5 6 44400 15 75 2 45000 8 52 3 45000 12 8 19 46200 12 52 3 48000 8 70 20 48000 12 6 23 48000 12 11 12 48000 12 11 17 48000 12 63 22 48000 12 144 24 48000 12 163 12...
Salary Education 42 6 48 7 82 1 46 3 67 1 54 5 105 6...
Salary Education 42 6 48 7 82 1 46 3 67 1 54 5 105 6 42 0 38 4 56 6 90 2 44 7 67 5 64 7 143 12 43 0 76 7 64 4 127 6 42 0 A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: a. Find...
A = [4, 5, 9] B = [-4, 5, -7] C = [2, -7, -8, 5]...
A = [4, 5, 9] B = [-4, 5, -7] C = [2, -7, -8, 5] D = [1, -9, 5, -3] E = [3, 3, -1] Uz = 1/|z| ^z d(X,Y) = (Rθ) d = diameter R = Radius θ = Theta Find a. Uc b. d (D, C) c. Let P = B + 3E, UP = d. A x B e. 3B x E f. C x D
4. (24) The average starting salary of a random sample of 100 high school students was...
4. (24) The average starting salary of a random sample of 100 high school students was found to be $31,840. The population standard deviation for all such individuals is known to be $9,840. a. (12) Ten years ago, the average starting salary was $25,000. Does the sample data support the claim that the starting salary for this group has increased? Use alpha = 0.05. b. (6) Describe in general Type I and Type II errors and the Power of the...
Q 0 1 2 3 4 5 6 7 8 TC 10 18 24 30 38...
Q 0 1 2 3 4 5 6 7 8 TC 10 18 24 30 38 50 66 91 120 AC 18 12 10 9.5 10 11 13 15 MC 8 6 6 8 12 16 25 29 TR 16 32 48 64 80 96 112 128 MR 16 16 16 16 16 16 16 16 A perfectly competitive TV production firm in Lost Angeles faces the above short-run cost schedule. The price per unit of output is £16. a)...
A = (1 −7 5 0 0 10 8 2 2 4 10 3 −4 8...
A = (1 −7 5 0 0 10 8 2 2 4 10 3 −4 8 −9 6) (1) Count the number of rows that contain negative components. (2) Obtain the inverse of A and count the number of columns that contain even number of positive components. (3) Assign column names (a,b,c,d) to the columns of A. (4) Transform the matrix A into a vector object a by stacking rows. (5) Replace the diagonal components of A with (0,0,2,3). Hint:...
Given: x y -5 1 -4 5 -3 4 -2 7 -1 10 0 8 1...
Given: x y -5 1 -4 5 -3 4 -2 7 -1 10 0 8 1 9 2 13 3 14 4 13 5 18 What are the confidence limits (alpha = 0.05) for the true mean value of Y when X = 3?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT