5)
X |
Y | XY | ||
1 | 6 | 1 | 36 | 6 |
2 | 8 | 4 | 64 | 16 |
3 | 7 | 9 | 49 | 21 |
4 | 5 | 16 | 25 | 20 |
5 | 3 | 25 | 9 | 15 |
6 | 4 | 36 | 16 | 24 |
7 | 1 | 49 | 1 | 7 |
8 | 2 | 64 | 4 | 16 |
Total=36 | 36 | 204 | 204 | 125 |
5) Or you can calculate it quickly using this formula
X |
Y | d= X-Y | |
1 | 6 | -5 | 25 |
2 | 8 | -6 | 36 |
3 | 7 | -4 | 16 |
4 | 5 | -1 | 1 |
5 | 3 | 2 | 4 |
6 | 4 | 2 | 4 |
7 | 1 | 6 | 36 |
8 | 2 | 6 | 36 |
Total=36 | 36 | 158 |
6)
Under Ho:
Test statistic is:
Since t(cal) =|-4.56009| = 4.56009 > 2.447 i.e t(tab) we have sufficient evidence to reject Ho at 5% level of significance
Is rs Significant? Yes
The p-value is .003851.
The result is significant at p < .05.
9)
MS= MEAN SUM OF SQUARES = SS/df
df | SS | MS | F | Significance F | |
Regression | 1 | 32.59524 | 32.59524/1=32.59524 |
32.59524/9.404762=20.79494 |
0.00385032 |
Residual | 6 | 9.404762 |
9.404762/6=1.56746 |
YES | |
Total | 7 | 42 |
10) Standard error of regression:
standard deviation of Y =
Standard error of regression:
Determine whether the regression equation is statisicallt significant (a=.05) and complete the source table below. 9)...
Use the dataset of ranks presented below for Questions 4-6. Note: Show your work on a separate sheet. You will be asked to upload a scan/picture at the end of the test. Therapist Ranking (x) Number of Clients Ranking (y) I 2 55 7 Compute the Spearman's rho correlation coefficient for the dataset. Express your answer to 3 decimal places. (The data are already in the form of ranks, there is no need to convert the scores.) QUESTION 5 What...
• Refer back to the data you worked with in Problems 1-4. Compute the slope and Intercept for the regression line where Client Expectations is the predictor (x) and Client Satisfaction is the criterion variable (Y) (6 pts): b = 0.69 a = 2.55 Regression Equation: Y= 2.55 +0.69x 9) Determine whether the regression equation is statistically significant (a = .05) and complete the source table below (8 pts). Source SS df MS Fobt Significant? (Y/N) Regression Residual Total solution:...
3. Complete the regression ANOVA table below: n=26 (x.y) pairs Source of Variance Sum of Squares DOF d.f. Mean Squares F Regression 1746 FSTAT= Error 8640 Fcrit= Total 10386 XXXXXXXXXXXXXXX Α = .05
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (Each pair of variables has a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The caloric content and the sodium content (in milligrams) for 6 beef hot dogs are shown in the table below. 120 340 120 370 (a) x 180 calories (c)...
The table below gives the n middle school students. Using this data, consider the equation of the regression line. bo t bi, for predict average for a middle school student based on the number of hours spent unsupervised each day may or may not be statistically significant for the data given. Remember, in practice, it would not be to make a umber of hours spent unsupervised each day as well as the overall grade averages for seven randomly selected ing...
A shoe store developed the following estimated regression equation relating sales to inventory investment and advertising expenditures where 1inventory investment ($1000s) = advertising expenditures ($1000s) y sales ($1000s) The data used to develop the model came from a survey of 10 stores; for those data, SST 16,000 and SSR a. Compute SSE, MSE, and MSR (to 2 decimals, if necessary) 12,000 SSE MSE MSR b. Use an F test and α .05 level of significance to determine whether there is...
Please show in excel regression tool step by step. The table below gives the age and bone density for five randomly selected women. Using this data, consider the equation of the regression line, y bo + bix. for predicting a woman's bone density based on her age. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice. it would not be appropriate to use the regression line to make a...
eBook Video In a regression analysis involving 30 observations, the following estimated regression equation was obtained. 17.6+3.8z-2.3z +7.6z, +2.7z For this estimated regression equation SST- 1805 and SSR- 1,764. a. At a 0.05, test the significance of the relashionship among the variables. SSE (to 1 decimal, if necessary) MSR (to 1 decimal, if necessary) MSE (to 2 decimal if necessary) What is the value of the F test statistic (to 1 decimal)? Use Table 4 in Appendix B. What is...
The table below gives the list price and the number of bids received for five randomly selected items sold through online auctions. Using this data, consider the equation of the regression line, yˆ=b0+b1xy^=b0+b1x, for predicting the number of bids an item will receive based on the list price. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make...
In a regression analysis involving 30 observations, the following estimated regression equation was obtained. = 17.6 +3.821 -2.3x2 + 7.603 + 2.724 For this estimated regression equation SST = 1805 and SSR = 1,756. a. At a = 0.05, test the significance of the relashionship among the variables. SSE (to 1 decimal, if necessary) MSR (to 1 decimal, if necessary) MSE (to 2 decimals, if necessary) What is the value of the F test statistic (to 1 decimal)? Use Table...