Question

In: Math

We performed a linear regression analysis between number of times on phone per drive and number...

We performed a linear regression analysis between number of times on phone per drive and number of near accidents. The equation is Y= 0.320 + 0.943X, where Y is the number of times on phone per drive and X is the number of near accidents. calculate the p-value and give a conclusion.

number of times on phone per dr near accidents
0 0
0 1
1 1
2 1
3 1
1 2
2 2
3 2
4 2
2 3
3 3
4 3
2 4
3 4
4 4
5 4
6 4
3 5
4 5
5 5
6 5
4 6
5 6
7 6
8 7
9 7

Solutions

Expert Solution

Let's calculate the F-statistic first whose formula is:

n = 26

The calculations are given below:

y

x yp (Predicted) = 0.320 + 0.943*x (y-u)*(y-u) (yp-u)*(yp-u) (y - yp)*(y-yp)
0 0 0.32 13.633 11.372 0.102
0 1 1.263 13.633 5.902 1.595
1 1 1.263 7.249 5.902 0.069
2 1 1.263 2.864 5.902 0.543
3 1 1.263 0.479 5.902 3.017
1 2 2.206 7.249 2.209 1.454
2 2 2.206 2.864 2.209 0.042
3 2 2.206 0.479 2.209 0.630
4 2 2.206 0.095 2.209 3.218
2 3 3.149 2.864 0.295 1.320
3 3 3.149 0.479 0.295 0.022
4 3 3.149 0.095 0.295 0.724
2 4 4.092 2.864 0.160 4.376
3 4 4.092 0.479 0.160 1.192
4 4 4.092 0.095 0.160 0.008
5 4 4.092 1.710 0.160 0.824
6 4 4.092 5.325 0.160 3.640
3 5 5.035 0.479 1.803 4.141
4 5 5.035 0.095 1.803 1.071
5 5 5.035 1.710 1.803 0.001
6 5 5.035 5.325 1.803 0.931
4 6 5.978 0.095 5.224 3.912
5 6 5.978 1.710 5.224 0.956
7 6 5.978 10.941 5.224 1.044
8 7 6.921 18.556 10.424 1.164
9 7 6.921 28.172 10.424 4.322
Average, u 3.692308 Total 129.538 89.233 40.327


SSR = 89.233

SSE = 40.327

F = (89.233/1) / (40.327/24) = 53.09368

p-value = 1.58E-07 (at df = 1, 24)

As the p-value < 0.05, we can conclude that the regression is significant at 0.01 level of significance.

SSE =


Related Solutions

In this problem, we will use linear regression and residual analysis to study the relationship between...
In this problem, we will use linear regression and residual analysis to study the relationship between square footage of a house and the home sales price. (a) Go to the course webpage and under Datasets, download the CSV file “homes.csv” and follow the accompanying Minitab instructions. Copy and paste the Fitted Line Plots and the Residual Plots in a blank document. Print these out and attach them to your homework. (b) Based on the fitted line and residual plots for...
13. Linear regression analysis was performed for a standard addition data set based on this experiment....
13. Linear regression analysis was performed for a standard addition data set based on this experiment. The analysis yielded the following results: m = 0.006110, b = 0.008170. What is the unknown's riboflavin concentration (ppm) in the standard addition solutions? a) 2.0 b) 13.37 c) 1.337 d) 1.67 15. The riboflavin concentration in the unknown powder solution is 58.0 ppm. The total volume of the powder solution is 250.00 mL. What is the concentration in the tablet (mg ribo/tablet) if...
In a simple linear regression, if we scale the data by a negative number, does the...
In a simple linear regression, if we scale the data by a negative number, does the t-statistic for the slope change to be the negative of the original result and the p-value for the slope change because the t-statistic for the slope changes?
4) You are hired by a cell phone provider to determine the number of times per...
4) You are hired by a cell phone provider to determine the number of times per day their customers interact with their smartphone. You take a random sample of 25 customers and find the average number of interactions to be 75 times per day with a sample standard deviation of 5. 4 a. If you decide to construct a confidence interval for the population mean number of interactions, what distribution would you use and why? ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ b. Construct...
4) You are hired by a cell phone provider to determine the number of times per...
4) You are hired by a cell phone provider to determine the number of times per day their customers interact with their smartphone. You take a random sample of 25 customers and find the average number of interactions to be 75 times per day with a sample standard deviation of 5. 4 a. If you decide to construct a confidence interval for the population mean number of interactions, what distribution would you use and why? ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ b. Construct...
Importance of linear regression in research analysis.
Importance of linear regression in research analysis.
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 6. Is there a significant relationship? Clearly explain your reasoning using the regression results. Number of Promotions Total Sales 3 2554 2 1746 11 2755 14 1935 15 2461 4 2727 5 2231 14 2791 12 2557 4 1897 2 2022 7 2673 11 2947 11 1573 14 2980
The regression line that gives the linear relationship between the number of seeds or pellets eaten...
The regression line that gives the linear relationship between the number of seeds or pellets eaten and the amount of time to eat the food is predicted amount of time to eat the food = 42.8565 – 0.0554(number of seeds or pellets eaten). Suppose one day Parsnip eats 30 seeds. Based on the regression line, how long do you predict it will take Parsnip to eat these 30 seeds?
Consider the regression we know that f there is a strong linear correlation between X and...
Consider the regression we know that f there is a strong linear correlation between X and Z, then it is more likely that the t-test statistics get smaller. Show and explain how. Explain what happens if t-statistics get smaller.
In a simple linear regression analysis, will the estimate of the regression line be the same...
In a simple linear regression analysis, will the estimate of the regression line be the same if you exchange X and Y? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT