EBK PRINCIPLES OF OPERATIONS MANAGEMENT
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
11th Edition
ISBN: 9780135175644
Author: Munson
Publisher: VST
bartleby

Videos

Textbook Question
Book Icon
Chapter 4, Problem 52P

Bus and subway ridership for the summer months in London, England, is believed to be tied heavily to the number of tourists visiting the city. During the past 12 years, the data on the next page have been obtained:

Chapter 4, Problem 52P, Bus and subway ridership for the summer months in London, England, is believed to be tied heavily to

a) Plot these data and decide if a linear model is reasonable.

b) Develop a regression relationship.

c) What is expected ridership if 10 million tourists visit London in a year?

d) Explain the predicted ridership if there are no tourists at all.

e) What is the standard error of the estimate?

f) What is the model’s correlation coefficient and coefficient of determination?

a)

Expert Solution
Check Mark
Summary Introduction

To determine: To plot the data and decide whether the linear model is reasonable.

Introduction: Forecasting is used to predict future changes or demand patterns. It involves different approaches and varies with different periods.

Answer to Problem 52P

The graph for the given data is plotted and it can be observed that the data points are scattered around.

Explanation of Solution

Given information:

Year (Summer Months) Number of tourist (in millions) Ridership (in millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

Table 1

Graphical representation:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, Chapter 4, Problem 52P , additional homework tip  1

The data to plot the graph is taken from Table 1.

Hence, the graph for the given data is plotted and it can be observed that the data points are scattered around.

b)

Expert Solution
Check Mark
Summary Introduction

To determine: A regression relationship.

Answer to Problem 52P

The linear regression equation is y^=0.511+0.159x .

Explanation of Solution

Given information:

Year (Summer Months) Number of tourist (in millions) Ridership (in millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

Formula of least square regression:

y^=a+bx

Where,

 y^=computed value of the variablea=y-axis interceptb=slope of the regression linex=the independent variable

b=xynx¯y¯x2nx¯2

Where,

b=slope of the regression line= summation signx=known values of the independent variablesy=known values of the dependent variables

x¯=average of the x - valuesy¯=average of the y - values= number of data points

Year (Summer Months) Number of tourist (in millions) (x) Ridership (in millions) (y) xy x^2 y^2
1 7 1.5 10.5 49 2.25
2 2 1 2 4 1
3 6 1.3 7.8 36 1.69
4 4 1.5 6 16 2.25
5 14 2.5 35 196 6.25
6 15 2.7 40.5 225 7.29
7 16 2.4 38.4 256 5.76
8 12 2 24 144 4
9 14 2.7 37.8 196 7.29
10 20 4.4 88 400 19.36
11 15 3.4 51 225 11.56
12 7 1.7 11.9 49 2.89
Total 132 27.1 352.9 1796 71.59

Table 2

Excel worksheet:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, Chapter 4, Problem 52P , additional homework tip  2

Substitute the values in the above formula.

Calculation of the average of x values x¯ :

x¯=i=112xn=13212=11

The average of x values is obtained by dividing the summation of x values with the number of periods n=12, the value of x¯ = 11.

Calculation of the average of y values y¯ :

y¯=i=112yn=27.112=2.26

The average of y values is obtained by dividing the summation of sales with the number of periods n=12. The value of y¯ = 2.26.

Calculation ofthe slope of regression line‘b’:

b=xynx¯y¯x2nx¯2=352.9(12×11×2.26)1796(12×112)=54.6344=0.159

The summation of the product of sales (y) with x values is ∑xy = 352.9, the product of number of period (n), the average of x values and the average of y values is obtained; nx¯y¯ =298.3. The difference between 352.9and 298.3 is 54.6.

The summation of the square of x values, 1796, is subtracted from the product of the number of periods, 10with the average of x values, 11. The resultant value is 344. The slope of the regression line is obtained by dividing 1796 with 344. The value of ‘b’ is 0.159.

Calculation of the y-axis intercept ‘a’:

a=y¯bx¯=2.26(0.159×11)=0.511

The y-axis intercept is obtained by the difference between the average of y values and values obtained by the product of the slope of regression line with the average of x values. The resultant value of ‘a’ is 0.511.

Least Square Regression forecasting equation:

y^=a+bx=0.511+0.159x (1)

Substitute the slope of regression line and they axis intercept in the regression equation which gives the liner regression equation for the data.

Hence, the linear regression equation is y^=0.511+0.159x .

c)

Expert Solution
Check Mark
Summary Introduction

To determine: The expected ridership when 10 million tourists visit in a year.

Answer to Problem 52P

There is a 2.101 million ridership when 10 million tourists visit in a year.

Explanation of Solution

Given information:

Year (Summer Months) Number of tourist (in millions) Ridership (in millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

Formula of least square regression:

y^=a+bx

Where,

 y^=computed value of the variablea=y-axis interceptb=slope of the regression linex=the independent variable

b=xynx¯y¯x2nx¯2

Where,

b=slope of the regression line= summation signx=known values of the independent variablesy=known values of the dependent variables

x¯=average of the x - valuesy¯=average of the y - values= number of data points

Calculation of number of ridership when 10 million touristsvisit in a year:

y^=0.511+0.159x=0.511+(0.159×10)=2.101millionpersons

Equation (1) provides the linear regression equation for the data and substitutes the number of tourists visiting in the regression equation. Substituting 10 million in the equation, the resultant value is found to be 2.101 million ridership.

Hence, there are 2.101 million ridership when 10 million touristsvisit in a year.

d)

Expert Solution
Check Mark
Summary Introduction

To determine: The expected ridership when no tourists visit in a year.

Answer to Problem 52P

There is a 511,000 ridership when no touristsvisit in a year.

Explanation of Solution

Given information:

Year (Summer Months) Number of tourist (in millions) Ridership (in millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

Formula of least square regression:

y^=a+bx

Where,

 y^=computed value of the variablea=y-axis interceptb=slope of the regression linex=the independent variable

b=xynx¯y¯x2nx¯2

Where,

b=slope of the regression line= summation signx=known values of the independent variablesy=known values of the dependent variables

x¯=average of the x - valuesy¯=average of the y - values= number of data points

Calculation of the number of ridership when notouristsvisit in a year:

y^=0.511+0.159x=0.511+(0.159×0)=0.511millionpersons=511,000persons

Equation (1) provides the linear regression equation for the data and substitutes the number of tourists visiting in the regression equation. Substituting 0 in the equation, the resultant value is 0.511 million ridership.

Hence, there is a 511,000 ridership when notouristsvisit in a year.

e)

Expert Solution
Check Mark
Summary Introduction

To determine: The standard error of estimate.

Answer to Problem 52P

The standard error of estimate is0.4037.

Explanation of Solution

Given information:

Year (Summer Months) Number of tourists(in millions) Ridership (in millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

Formula to compute the standard error of estimate:

Syx=(yyc)2n2y=valueofeachdatapointyc=Computedvalueofthedependentvariablefromtheregressionequationn=numberofdatapoints

syx=y2aybxyn2

Calculation of standard error of estimate:

Syx=y2aybxyn2=71.59(0.511×27.1)(0.159×352.9)122=0.163=0.4037

The values to be substituted in the standard error of estimate formula are given inTable 2. Substitute the values from the table in the formula. This results in a standard error of estimate of 0.4037.

Hence, the standard error of estimate is 0.4037.

f)

Expert Solution
Check Mark
Summary Introduction

To determine: The coefficient of correlation (r) and coefficient of determination (r2).

Answer to Problem 52P

The coefficient of correlation (r) and coefficient of determination (r2) are 717.41 & 0.840, respectively.

Explanation of Solution

Given information:

Year (Summer Months) Number of tourists(in millions) Ridership (in millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

Formula to calculate the correlation coefficient:

r=nxyxy(nx2(x)2(ny2(y))2)

Calculation of the correlation coefficient (r):

Table (2) provides the values to calculate the correlation coefficient (r).

r=nxyxy(nx2(x)2(ny2(y))2)=(12×352.9)(132×27.1)((12×1796)1322)((12×71.59)(27.1)2)=657.62934.31=717.41

Calculation of the correlation of determination (r2):

r2=r×r=0.917×0.917=0.840

Hence, the coefficient of correlation and coefficient of determination are 717.41 and 0.840, respectively.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 25 45 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = - 5 + 25.5 x Using least-squares regression, the forecast for the number of accidents that will occur in the month of May = 122.5 accidents (enter your response as a whole number).
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances Demand for Guitars 4 Y = 3 4 5 D 5 6 7 7 7 4 10 6 This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): = 0+0x
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table:                          Maroon 5 Tv Appearances        3 4 7 6 8 5                            Demand for Guitars                  3  6  7  5  10  7    b) Using the least-squares regression method, the equation for forecasting is (round your response to four decimal places):        Y= _____+_____X C) The estimate for guitar sales if Maroon 5 performed on Tv 9 times =___ (round your response to 2 decimal places

Chapter 4 Solutions

EBK PRINCIPLES OF OPERATIONS MANAGEMENT

Ch. 4 - What is the primary difference between a...Ch. 4 - Define time series.Ch. 4 - What effect does the value of the smoothing...Ch. 4 - Explain the value of seasonal indices in...Ch. 4 - Prob. 14DQCh. 4 - In your own words, explain adaptive forecasting.Ch. 4 - Prob. 16DQCh. 4 - Explain, in your own words, the meaning of the...Ch. 4 - Prob. 18DQCh. 4 - Give examples of industries that are affected by...Ch. 4 - Prob. 20DQCh. 4 - Prob. 21DQCh. 4 - CEO John Goodale, at Southern Illinois Power and...Ch. 4 - The following gives the number of pints of type B...Ch. 4 - a) Plot the above data on a graph. Do you observe...Ch. 4 - Refer to Problem 4.2. Develop a forecast for years...Ch. 4 - A check-processing center uses exponential...Ch. 4 - The Carbondale Hospital is considering the...Ch. 4 - The monthly sales for Yazici Batteries, Inc., were...Ch. 4 - Prob. 7PCh. 4 - Daily high temperatures in St. Louis for the last...Ch. 4 - Lenovo uses the ZX-81 chip in some of its laptop...Ch. 4 - Data collected on the yearly registrations for a...Ch. 4 - Use exponential smoothing with a smoothing...Ch. 4 - Prob. 12PCh. 4 - At you can see in the following table, demand for...Ch. 4 - Prob. 14PCh. 4 - Refer to Solved Problem 4.1 on page 144. a) Use a...Ch. 4 - Prob. 16PCh. 4 - Prob. 17PCh. 4 - Prob. 18PCh. 4 - Income at the architectural firm Spraggins and...Ch. 4 - Resolve Problem 4.19 with = .1 and =.8. Using...Ch. 4 - Prob. 21PCh. 4 - Refer to Problem 4.21. Complete the trend-adjusted...Ch. 4 - Prob. 23PCh. 4 - The following gives the number of accidents that...Ch. 4 - In the past, Peter Kelles tire dealership in Baton...Ch. 4 - George Kyparisis owns a company that manufactures...Ch. 4 - Attendance at Orlandos newest Disneylike...Ch. 4 - Prob. 28PCh. 4 - The number of disk drives (in millions) made at a...Ch. 4 - Prob. 30PCh. 4 - Emergency calls to the 911 system of Durham, North...Ch. 4 - Using the 911 call data in Problem 4.31, forecast...Ch. 4 - Storrs Cycles has just started selling the new...Ch. 4 - Prob. 35PCh. 4 - Prob. 36PCh. 4 - Prob. 37PCh. 4 - Prob. 38PCh. 4 - Prob. 39PCh. 4 - Prob. 40PCh. 4 - Prob. 41PCh. 4 - Prob. 42PCh. 4 - Mark Gershon, owner of a musical instrument...Ch. 4 - Prob. 44PCh. 4 - Cafe Michigans manager, Gary Stark, suspects that...Ch. 4 - Prob. 46PCh. 4 - The number of auto accidents in Athens, Ohio, is...Ch. 4 - Rhonda Clark, a Slippery Rock, Pennsylvania, real...Ch. 4 - Accountants at the Tucson firm, Larry Youdelman,...Ch. 4 - Prob. 50PCh. 4 - Using the data in Problem 4.30, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Prob. 53PCh. 4 - Dave Fletcher, the general manager of North...Ch. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Sales of tablet computers at Ted Glickmans...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Prob. 1CSCh. 4 - Prob. 2CSCh. 4 - Prob. 3CSCh. 4 - Prob. 1.1VCCh. 4 - Prob. 1.2VCCh. 4 - Using Perezs multiple-regression model, what would...Ch. 4 - Prob. 1.4VCCh. 4 - Prob. 2.1VCCh. 4 - Prob. 2.2VCCh. 4 - Prob. 2.3VCCh. 4 - Prob. 2.4VCCh. 4 - Prob. 2.5VC
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
    Text book image
    Contemporary Marketing
    Marketing
    ISBN:9780357033777
    Author:Louis E. Boone, David L. Kurtz
    Publisher:Cengage Learning
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License