Question

In: Statistics and Probability

Type or pa A study by Metro Bus Service on the effect of bus-ticket prices on...

Type or pa

  1. A study by Metro Bus Service on the effect of bus-ticket prices on the number of passengers produced the following results:

Ticket Price:        25           30           35           40           45           50           55           60

Pssngrs/100 m   800         700         780         660         640         600         620         620

  1. Plot these dat
  2. Develop the estimating equation that best describe these data.
  3. How can we ensure that the above model best used for provided data?
  4. Predict the number of passengers per 100 miles if the ticket price were 50. Use 95% approximate prediction interval.v

ste question here

Solutions

Expert Solution

Using Excel<data<data analysis<regression

Regression Analysis
0.727
r   -0.853
Std. Error   42.845
n   8
k   1
Dep. Var. Passengers
ANOVA table
Source SS   df   MS F p-value
Regression 29,335.7143 1   29,335.7143 15.98 .0071
Residual 11,014.2857 6   1,835.7143
Total 40,350.0000 7  
Regression output confidence interval
variables coefficients std. error    t (df=6) p-value 95% lower 95% upper
Intercept 902.1429 58.20 15.50 0.00 759.73 1044.56
ticket Price -5.2857 1.3222 -3.998 .0071 -8.5211 -2.0503
Predicted values for: Passengers
95% Confidence Interval 95% Prediction Interval
Predicted lower upper lower upper Leverage
637.857 593.555 682.160 524.042 751.672 0.179

Plot these data

Develop the estimating equation that best describe these data.

y=902.1429-5.2857x

or

Passengers=902.1429-5.2857* Ticket Price

Here Intercept= 902.1429

slope=5.2857

How can we ensure that the above model best used for provided data?

We have to find the relationship between the two variables so the regression is the best method to mid the relationship between two variables that is bus-ticket prices and the number of passengers.

Predict the number of passengers per 100 miles if the ticket price were 50. Use 95% approximate prediction interval.

Put ticket price =50 in the regression equation:

Passengers=902.1429-5.2857* 50

=637.857

The number of passengers is 638.

The 95% prediction interval is (524.042,751.672).


Related Solutions

Write a program for Bob’s Bus Company that allows a user check on ticket prices following...
Write a program for Bob’s Bus Company that allows a user check on ticket prices following the guidelines below: Zones Crossed --------------------------- Passengers 0 1 2 3 ---------------------------------------- 1 7.50 10.00 12.00 12.75 2 14.00 18.50 22.00 23.00 3 20.00 21.00 32.00 33.00 4 25.00 27.50 36.00 37.00 The user enters ticket data (number of passengers and number of zones crossed) continuously until a sentinel value, -1 for passengers, is entered. When -1 is entered for number of passengers, there...
The Acmeville Metropolitan Bus Service currently charges $ 0.99 for an all-day ticket, and has an...
The Acmeville Metropolitan Bus Service currently charges $ 0.99 for an all-day ticket, and has an average of 623 riders a day. The bus company is not earning a profit, but according to their contract with the city, they cannot cut the number of buses on the road. They must therefore find a way to increase revenues. The bus company is considering increasing the ticket price to $ 1.1 . The marketing department's studies indicate this price increase would reduce...
These transactions relate to Metro Bus, which provides transportation services to residents of Parker County. Metro...
These transactions relate to Metro Bus, which provides transportation services to residents of Parker County. Metro Bus is accounted for as a County Enterprise Fund. Prepare journal entries to record the following transactions in the Enterprise Fund. 1. On April 1, Metro borrows $2,500,000 by issuing 10-year revenue bonds. Bond       principal is to be paid back in 20 equal semi-annual installments, starting October 1,         together with interest of 5% a year on the unpaid principal. 2. On August...
Metro Transit seeks to understand the cross price elasticity of demand for bus transit.
Metro Transit seeks to understand the cross price elasticity of demand for bus transit. This dataset includes deseasonalized ridership data for one of the Metro Transit commuter markets from January 2009 to May of 2016 along with gas price and unemployment data in the twin cities region. The data are all in natural log form and we will assume constant elasticity/log-linear functional form for this analysis. Metro Transit has not changed the price during this period, so we will not...
Metro Bus Company had $400,000 of revenue and $401,000 of expense (including depreciation) for the current...
Metro Bus Company had $400,000 of revenue and $401,000 of expense (including depreciation) for the current year resulting in a $1,000 net loss. All revenues were received in cash. All expenses were paid in cash, except for depreciation of $181,000. At the end of the year, the Balance Sheet shows $225,000 of Cash and $1,775,000 of other assets. The Company has no debt and all of the busses are modern - there is no plan to purchase more busses. Although...
If the Detroit Pistons raise their ticket prices and see ticket revenues fall (holding all else...
If the Detroit Pistons raise their ticket prices and see ticket revenues fall (holding all else equal), we can conclude that a. the supply of tickets is too high. b. the demand for tickets is too low. c. the demand for tickets is price inelastic. d. the demand for tickets is price elastic.
Instructor - Lead Question Metro Bus Company had $400,000 of revenue and $401,000 of expense (including...
Instructor - Lead Question Metro Bus Company had $400,000 of revenue and $401,000 of expense (including depreciation) for the current year resulting in a $1,000 net loss. All revenues were received in cash. All expenses were paid in cash, except for depreciation of $181,000. At the end of the year, the Balance Sheet shows $225,000 of Cash and $1,775,000 of other assets. The Company has no debt and all of the busses are modern - there is no plan to...
Kevin is organizing luxury bus tickets to Lynnwood from Shoreline. If the ticket price is $200,...
Kevin is organizing luxury bus tickets to Lynnwood from Shoreline. If the ticket price is $200, then Kevin can sell 80 tickets. For each five dollars Kevin increases the price, one fewer ticket is sold. (a) If tickets are sold for $(200 + 5x) each (that is, if Kevin raises the price by $5 x times), how many are sold? _____ tickets (b) Express the total amount of money Kevin gets by selling tickets for $(200 + 5x) each. Simplify...
A researcher wanted to study the effect of type of diet on weight gain in mice....
A researcher wanted to study the effect of type of diet on weight gain in mice. The researcher was interested in 3 specific diets: standard mouse chow diet, “junk” food diet, and an organic diet.  A total of 54 mice were randomly assigned to receive one of the 3 types of diets (18 in each group). The outcome variable (response variable) was weight gain (in grams) over a 1 month period. The 3 data sets provided below are for the same...
A researcher wanted to study the effect of type of diet on weight gain in mice....
A researcher wanted to study the effect of type of diet on weight gain in mice. The researcher was interested in 3 specific diets: standard mouse chow diet, “junk” food diet, and an organic diet.  A total of 54 mice were randomly assigned to receive one of the 3 types of diets (18 in each group). The outcome variable (response variable) was weight gain (in grams) over a 1 month period. The 3 data sets provided below are for the same...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT