Almost all U.S. light-rail systems use electric cars that run on tracks built at street level....

50.1K

Verified Solution

Question

Basic Math

Almost all U.S. light-rail systems use electric cars that run ontracks built at street level. The Federal Transit Administrationclaims light-rail is one of the safest modes of travel, with anaccident rate of .99 accidents per million passenger miles ascompared to 2.29 for buses. The following data show the miles oftrack and the weekday ridership in thousands of passengers for sixlight-rail systems.

CityMiles of TrackRidership (1000s)
Cleveland1716
Denver1936
Portland4082
Sacramento2332
San Diego4976
San Jose3331
St. Louis3643
  1. Use these data to develop an estimated regression equation thatcould be used to predict the ridership given the miles oftrack.

    Compute b0 and b1 (to 2decimals).
    b1
    b0

    Complete the estimated regression equation (to 2 decimals).
    =  +  x
  2. Compute the following (to 1 decimal):
    SSE
    SST
    SSR
    MSE

  3. What is the coefficient of determination (to 3 decimals)? Note:report r2 between 0 and 1.


    Does the estimated regression equation provide a good fit?
    SelectYes, it even provides an excellent fitYes, it provides a goodfitNo, it does not provide a good fitItem 10
  4. Develop a 95% confidence interval for the mean weekdayridership for all light-rail systems with 30 miles of track (to 1decimal).
    (  ,  )
  5. Suppose that Charlotte is considering construction of alight-rail system with 30 miles of track. Develop a 95% predictioninterval for the weekday ridership for the Charlotte system (to 1decimal).
    (  ,  )

Answer & Explanation Solved by verified expert
4.2 Ratings (795 Votes)
The regression analysis is done in excel by following thesestepsStep 1 Write the data values in excelStep 2 DATA Data Analysis Regression OK Thescreenshot is shown belowStep 3 Select Input Y Range Y column Input X Range    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students