Screenshot 2024-05-19 at 10

.png

School

Embry-Riddle Aeronautical University *

*We aren’t endorsed by this school

Course

302

Subject

Statistics

Date

May 21, 2024

Type

png

Pages

1

Uploaded by BrigadierJellyfish17368

Question 3 0/ 1 point The following data represent the weight of a child riding a bike and the rolling distance achieved after going down a hill without pedaling. Welghtm"Ilns Ibs.) Distance ( (m.) 59 26 83 43 97 49 56 20 103 65 87 44 88 48 91 42 52 39 63 33 71 39 100 49 89 55 103 53 99 42 74 33 75 30 89 30 102 40 103 33 99 33 102 35 86 37 85 37 Find the 99% prediction interval for rolling distance when a child riding the bike weighs 99 Ibs. (round to 4 decimal places) J <)-< Answer for blank # 1: 22.2568 x (19.3556) Answer for blank # 2: 68.7688 x (69.3966) w Hide question 3 feedback Copy and paste the data into Excel. Then use the Data Analysis Toolpak and run a Regression. The y-variable is the distance and the x-variable is the weight. How far the bike will travel will depend on the weight of the child. You want to predict the distance of the bike. Once you get the Regression output, look under the Coefficients to find the values to use for the regression equation. y = 10.3364819 + 0.343834842 (x) Plug 99 in for x and solve. y = 10.3364819 + 0.343834842 (99) y = 44.37613122, this is our y-hat value. This is the equation to use for the prediction interval 5 1 (wo—2)? gEtx(SE) 1+ n i (n —1)SDz? T-Critical Value =T.INV.2T(.01, 22) = 2.818756061 The SE we get from the Regression output and you can use Excel to find the Average and SD of the Weight variable. LL = 44.37613122- 2.818756061%8.573835284" 1 (99 — 85.6667)2 1+ —+ 5 24 (24 —1)%16.00724 UL = 44.37613122+ 2.818756061"8.573835284" 1 (99 — 85.6667)> 14+ + 5 24 ' (24— 1) %16.00724
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help