Given the data listed in the table, calculate the lower and upper bound for the 95% confidence interval for the mean at X = 6. The regression equation is given by y^ = b0 + b1x.
Regression Statistics | ||
---|---|---|
Statistic | Value | |
b0 | 8.2 | |
b1 | 0.64 | |
x | 4.82 | |
se | 1.280 | |
SSX | 26.23 | |
SST | 45.52 | |
n | 40 |
Give your answers to 2 decimal places. You may find this Student's t distribution table useful.
a) Lower bound =
b)Upper bound =
Given the data listed in the table, calculate the lower and upper bound for the 95%...
A straight line is fitted to some data using least squares. Summary statistics are below. n=10, I = 5, y =12, SSxx=139, SSxy=128, SSyy=155 The least squares intercept and slope are 7.40 and 0.92, respectively, and the ANOVA table is below. Source DF SSMS Regression 1 117.87 117.87 Residual 8 37.13 4.64 Total ||155 [2 pt(s)] What is the estimated mean value for y when x=8? Submit Answer Tries 0/3 [2 pt(s)] If the fitted value for y is 20,...
5. Summary of regression between a dependent variable y and two independent variables X, and x2 is as follows. Please complete the table: SUMMARY OUTPUT Regression Statistics Multiple R 0.9620 R Square R2E? Adjusted R Square 0.9043 Standard Error 12.7096 Observations 10 ANOVA F Significance F F=? Overall p-value=? Regression Residual Total 2 df of SSE MS MSR=? MSE? 14052.1550 1130.7450 SSTE? MSE? 9 Coefficients -18.3683 Standard Error 17.9715 t Stat -1.0221 Intercept ty=? 2.0102 4.7378 0.2471 0.9484 P-value 0.3408...
Tries for critical value: 5.3177, 1.86, 4.8205 A straight line is fitted to some data using least squares. Summary statistics are below. n=10, 7=5,5=12, SSxx=142, SSxy=128, SSyy=155 The least squares intercept and slope are 7.50 and 0.90, respectively, and the ANOVA table is below. Source DF SSMS Regression 1 115.38 115.38 Residual 8 39.62 4.95 Total 9 155 What is the estimated mean value for y when x=10? 16.5000 (2 pt(s)] You are correct. Your receipt no. is 155-2037 Previous...
A sample with two variables (x and y) is given in the table. According to the sample, please develop an excel spreadsheet to calculate the missing values given in the table of “summary output” attached below. The excel spreadsheet needs to be submitted together with your assignment. Note: You can use “data analysis toolpak” to check your answers, but calculations should be based on the formulas that we learnt in module 2. x y 1.0 5.2 1.5 7.2 2.0 5.5...
B. The table below lists the sales, y (in millions of dollars) and the number of employees, x (in thousands) for a random sample of 20 Fortune 500 companies. The regression results based on the model are given below. Some of the numbers in the regression tables have been taken out. SUMMARY OUTPUT Regression Statistics Multiple R (1) R Square (2) Adjusted R Square 0.837364 Standard Error (3) Observations (4) ANOVA df SS MS F Significance F Regression (5) (7)...
Table 6 It is believed that, the average numbers of hours spent studying per day (HOURS) during undergraduate education should have a positive linear relationship with the starting salary (SALARY, measured in thousands of dollars per month) after graduation. Given below is the Excel output for predicting starting salary (Y) using number of hours spent studying per day (X) for a sample of 51 students. NOTE: Only partial output is shown. Note: 2.051E - 05 = 2.051 ∗ 10-05 and...
Lab 3: Homework Assignment (30 pts.) Using the data from Table 2 below, calculate the statistics and fill in the cells of Worksheet 1 below. Use these data to make a table in MS Excel that lists the population name (Lake) and the sample statistics for each population including mean ducklings fledged, median, DF, SS, s2, SD, SE, and tos(SE) for each of the populations. (10 pts) Use Table 3 below as a template to construct your table in MS...