Question
theres 4 total questions
oare Was teR Mailed to these tive cardhoiders requesting intormation on the numbe time period. The data follow. Sick Days & A
01:41:34 A regression Analysis has been performed to estimate the model and the output is given. Regression Statistics Multip
74.45873 Total Coefficients Standard Error t Stat value 00169 14864 69394 0.69847 68580 42158 Intercept Miles 38633 1.65679 S
ANOVA MS ignificance 14864 Regression Residual Total 1.39955 6 3.05918 4.45873 1.39955 2.74495 50986 Standard Error 0.68580 0
ANOVA MS 1.39955 f SS ignificance F 14864 11.39955 6 3.05918 74.45873 74495 egression esidual otal 50986 Lower 95% 2.01585 P-
ANOVA df ss MS 1.39955 0.50986 Significance F 0.14864 egression esidual otal 11.39955 6 3.05918 45873 2.74495 Upper 9 oeffici
oare Was teR Mailed to these tive cardhoiders requesting intormation on the numbe time period. The data follow. Sick Days & Age iles 1,000's)K$1,000's) harges Cardholder 1.2 2.0 1.5 2.3 2.7 1.6 2.5 2.2 4.2 3.2 2.7 0.5 2.1 0.8 reA regression Analysis has been performed to estimate the model and the output is given. Regression Statistics Multiple R R Square Adjusted R Square ,19954 56026 0.31389 71405 tandard Error bservations ANOVA O 2019
01:41:34 A regression Analysis has been performed to estimate the model and the output is given. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.56026 31389 19954 71405 ANOVA nificance 14864 11.39955 3.05918 7 4.45873 1,39955 .50986 74495 Regression Residual Total ev upper 95% 7204 Lower 95% 1585 73004 -value 00169 .14864 Stat 38633 1.65679 Coefficients 3.69394 Standard Error intercept Miles 310 .421 58 step 1 of 4: What is the slope of the estimated regression equation? (Report to 2 decimal places.) Keypad Tables Answer 1 Point 019 Hawkes Learning
74.45873 Total Coefficients Standard Error t Stat value 00169 14864 69394 0.69847 68580 42158 Intercept Miles 38633 1.65679 Step 1 of 4: What is the slope of the estimated regression equation? (Report to 2 decimal places.) Answer 1 Point 9 Hawkes Learning
ANOVA MS ignificance 14864 Regression Residual Total 1.39955 6 3.05918 4.45873 1.39955 2.74495 50986 Standard Error 0.68580 0,42158 P-value 00169 14864 Coefficients 3.69394 0.69847 over 95% 01585 1.73004 t Stat pper 95% 5.37204 ntercept Miles 5.38633 1.65679 33310 Step 2 of 4: What fraction of the variation in credit card charges is explained by miles traveled? (Report as a decimal fraction to 2 decimal place m Tables Keypad Answer 1 Point wkes Learning
ANOVA MS 1.39955 f SS ignificance F 14864 11.39955 6 3.05918 74.45873 74495 egression esidual otal 50986 Lower 95% 2.01585 P-value 00169 14864 Stat 38633 1.65679 Coefficients 3.69394 0.69847 Standard Error 0.68580 ntercept Miles 1.73004 42158 Step 3 of 4: Determine the 95% confidence interval for ß-the slope of the line. (Report to 3 decimal places.) Tables Answer Point
ANOVA df ss MS 1.39955 0.50986 Significance F 0.14864 egression esidual otal 11.39955 6 3.05918 45873 2.74495 Upper 9 oefficients 69394 t Stat 5.38633 1.65679 Standard Error 0.68580 0.42158 value 00169 14864 Lower 95% 2.01585 Intercept Miles 37204 0.33310 0.69847 1.73004 Step 4 of 4: Determine the 95% confidence interval for the average credit card charges, given that the cardholder traveled 2 thousand miles. (Report answer to 2 decimal places.) Answer 1 Point Thousand Dollars Lower lawkes Learning
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Q1: Slope of the estimated regression equation= -0.69847 = -0.70

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

Q2: Fraction of the variation in credit card charges that is explained by miles traveled = 0.3139 = 0.31

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

Q3: 95% confidence interval for β1 :

Lower = -1.730

Upper = 0.333

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

Q4: Regression equation :               
ŷ = 3.69394 - 0.69847 x

Predicted value at X = 2      
ŷ = 3.69394 - 0.69847 * 2 = 2.297   

Standard error, se = 0.71405

Standard error for slope, seb = 0.42158

x̅ = Ʃ x /n = 1.5125

At α = 0.05 and df = n-2 = 6, critical value, t_c = T.INV.2T(0.05, 6) =  2.4469

95% Confidence interval for the average credit card charges:

tc * se n se/se) 1 (2 -1.5125)2 2.297 ± 2.4469 * 0.71405, + 8 (0.71405/0.42158)2 1.50, 3.09)

Lower: 1.50 Thousand Dollars.

Upper: 3.09 Thousand Dollars.

Add a comment
Know the answer?
Add Answer to:
theres 4 total questions oare Was teR Mailed to these tive cardhoiders requesting intormation on the numbe time period. The data follow. Sick Days & Age iles 1,000's)K$1,000's) ha...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 01:37:49 Question 2of 28 Step 1 of 4 A regression Analysis has been performed to estimate the model and the output is given. Regression Statistics 91092 82977 80140 23581 ultiple R justed R Sq...

    01:37:49 Question 2of 28 Step 1 of 4 A regression Analysis has been performed to estimate the model and the output is given. Regression Statistics 91092 82977 80140 23581 ultiple R justed R Square tandard Error bservations 8 ANOVA gnificance F 00165 df SS 24652 gression esidual otal 1,62635 0.05561 1,62635 33365 96000 -Upper 95% tStat 1430070 -5.40789 P-value 0.00001 00165 Lower 95% tandard Error 22648 13923 fficients 23882 0.75294 Ne Prev 68465 1.09362 9300 41226 ntercept iles Step 1...

  • The College of Business at Northeast College is accumulating data as a first step in the...

    The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 136,301 1,000 August 96,613 721 September 246,580 1,998 October 244,394 1,606 November 293,263 1,915 December 226,449 1,718 January...

  • The ACT is a standardized test that many high school students in the U.S. take in...

    The ACT is a standardized test that many high school students in the U.S. take in order to apply for college (the other major admissions test is the SAT). Scores on the ACT range from 1 to 36 in one point increments. The dean of a college of business is interested in examining the relationship between ACT scores and GPAs of students in the college. After taking a random sample of 141 students, he performs a regression analysis using Excel...

  • Hello I need help with questions 2 until question 9 if you can do that for me thanks. I need to s...

    Hello I need help with questions 2 until question 9 if you can do that for me thanks. I need to see all work and answers clearly. Thanks for the help I know it’s a lot but I really need help with this it’s a project that’s due tonight. Thanks ! 27 27889.0526471 10.12 1.09 28 SUMMARY OUTPUT 29 30 Regression Statistics 1 Multiple F 0.986442 32 R Square 0.973068 33 Adjusted 0.967681 34 Standard I 32.55341 35 Observati 36...

  • Hello I need help with questions 2 until 9 if possible. If you can please show all work and answe...

    Hello I need help with questions 2 until 9 if possible. If you can please show all work and answers clearly. Thanks for all the help have this project that’s due tonight so I need help on thanks. 27 27889.0526471 10.12 1.09 28 SUMMARY OUTPUT 29 30 Regression Statistics 1 Multiple F 0.986442 32 R Square 0.973068 33 Adjusted 0.967681 34 Standard I 32.55341 35 Observati 36 37 ANOVA 38 39 Regressio 40 Residual 41 Total 42 43 44 Intercept...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT