Lesson10AClassActivity
.xlsx
keyboard_arrow_up
School
Brigham Young University, Idaho *
*We aren’t endorsed by this school
Course
108X
Subject
Management
Date
Apr 3, 2024
Type
xlsx
Pages
44
Uploaded by Eleanoriclements on coursehero.com
Olivia's Honda Civic
Which trend line is best for Insert a scatterplot of Olivia's data here.
Estimated sales price of a 9 year-old Honda Civic:
Estimated sales price of an 18 year-old Honda Civic:
If necessary revisit the Olivia example from the Lesson 10 Rea
Use your trendline equation to estimate, or predict, the sales price and a Honda Civic that is 18 years old.
0
2
4
6
8
10
12
14
16
18
$0.00
$2,000.00
$4,000.00
$6,000.00
$8,000.00
$10,000.00
$12,000.00
$14,000.00
$16,000.00
$18,000.00
$20,000.00
f(x) = 18421.8364737423 exp( − 0.099893637138979 x )
Sale Price
Olivia's data?
Olivia's Data
Input Variable
Output Variable
Age of Car
Sale Price
0
$18,900.00
1
$16,000.00
3
$12,995.00
4
$11,900.00
6
$10,299.00
7
$9,400.00
8
$9,190.00
13
$4,950.00
14
$4,650.00
17
$3,200.00
$7,489.83
$3,045.14
of a Honda Civic that is 9 years old
Input Variable:
Team Payroll
Output Variable:
Win Percentage
Follow this link to the textbook to review steps for creating a trendline in Excel:
Billy and Brad are brothers who are obsessed with baseball. They want to predict which teams will win based on the team payroll. They assume that better payers earn more money. Therefore they believe that teams with high payrolls are more likely to win. They want to use data to see if their belief is valid. They plan to create a trendline to predict winning percentage based on total payroll. Determine the input and output variables for this situation:
Billy and Brad find the following data for the last few years for Major League Baseball teams in the United States.
Create a scatterplot of the data. Then determine which type of trendline is most appropriate for this data. Add the trendline to your scatterplot. http://www.byuimath.com/fdmat108/Lesson9.html#excel_instructions_-_trendlines Billy's favorite team is the Oakland A's. In 2018, the Oakland A's payroll was a total of $50.7 million. Brad's favorite team is the New York Yankees. In 2018, the Yankee's payroll was a total of $158.5 million. Use your trendline equation to predict the winning percentage for each team.
Oakland A's predicted winning percentage:
75.81526
NY Yankee's predicted winning percentage:
90.0233
percentage for each team.
Does the scatterplot and trendline support Billy and Brad's assumption that teams with high payrolls are likely to win a greater percentage of their games than teams with lower payrolls? Why or why not?
If roughly supports Billys and Brads assumption because the graph follows a line going upward roughly.
If the Data did not folllow a pattern and it was all over the place. What kind of situation would lead Billy and Brad to re-evaluate their reasoning?
Win Percentage
Insert Scatterplot here
216.10
93.33
146.66
92.33
127.40
91.33
119.57
84.67
115.16
82.67
114.40
94.33
110.05
75.67
108.16
85.67
103.53
83.67
102.60
88.67
101.81
82.33
101.69
80.33
94.20
73.00
92.44
78.33
Team Payroll (in millions of dollars)
30
40
50
60
70
80
90
100
f(x) = 0.131817335115894 x + 69
Win Per
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. (Hint: Provides your answers in two decimal points)Table 1
Quarter
% change
in income
% Change in
appliance sold
Quarter
% change
in income
% Change in
appliance sold
1
-2.3
-2.5
6
-1.0
1.0
2
-1.5
-1.0
7
0.7
1.4
3
2.8
7.4
8
5.2
3.4
4
0.5
2.6
9
-2.5
-0.5
5
4.6
8.5
10
1.7
1.8
(a) Identify which is the dependent variable and independent variable in this case.
(b) Develop the forecasting model from this data.
(c) Identify the nature of the relationship between two variables based on the data that you have here.
arrow_forward
An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. (Hint: Provides your answers in two decimal points)Table 1
Quarter
% change
in income
% Change in
appliance sold
Quarter
% change
in income
% Change in
appliance sold
1
-2.3
-2.5
6
-1.0
1.0
2
-1.5
-1.0
7
0.7
1.4
3
2.8
7.4
8
5.2
3.4
4
0.5
2.6
9
-2.5
-0.5
5
4.6
8.5
10
1.7
1.8
(a) What forecasting model should be used for this data. Why?
(b) Develop the forecasting model that you have proposed in (a)
arrow_forward
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below).
Year
Sales
1
455
2
510
3
518
4
570
5
590
a) Forecasted sales for year 6 using the trend projection (linear regression) method are
627.6627.6
sales (round your response to one decimal place).
b) The MAD for a linear regression forecast is
nothing
sales (round your response to one decimal place).
arrow_forward
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft = 6 + 4t. Over the past nine quarters, demand has been as follows:
Period, t:
1
2
3
4
5
6
7
8
9
Demand:
11
15
17
22
28
32
36
39
43
Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.)
Period, t
Demand
MAD
Tracking signal
1
11
2
15
3
17
4
22
5
28
6
32
7
36
8
39
9
43
arrow_forward
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows:
a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.)
arrow_forward
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below).
Year
Sales
1
455
2
510
3
518
4
570
5
590
a) Forecasted sales for year 6 using the trend projection (linear regression) method are
nothing
sales (round your response to one decimal place)
arrow_forward
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below).
Year
Sales
1
450
2
502
3
520
4
570
5
575
a) Forecasted sales for year 6 using the trend projection (linear regression) method aresales (round your response to one decimal place).
b) The MAD for a linear regression forecast is
nothing
sales (round your response to one decimal place).
arrow_forward
Sales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see table below).
Year
Sales
1
460
2
502
3
518
4
575
5
580
Part 2
a) Forecasted sales for year 6 using the trend projection (linear regression) method are
enter your response here
sales (round your response to one decimal place).
arrow_forward
When a new business is started, or a patent idea needs funding, venture capitalists or investment bankers will want to see a business plan that includes forecast information related to profit and loss statements. What type of forecasting information do you think would the investors be looking for? Why?
arrow_forward
Given the demand data, answer the following questions below.
Year Sales
1 - 123
2 - 118
3 - 109
4 - 112
5 -100
6 -110
7 -124
8 - ?
What will be the forecast demand in Year 8 using Naïve method?a.) 120b.) 110c.) 115d.) 124
arrow_forward
You are getting into a business and want to take a loan. The bank requires that you show them your projected profits. Develop calculate a forecast for the next five years starting 2024 the following data: First order is for 100,000 units at a selling price of 6kshs per unit. Both numbers are projected to increase by 20% yearly Renting the production facility at 500,000kshs a year for five years Variable manufacturing cost of 1.50kshs per unit with a projected increase of 10% yearly Administration cost of 25,000kshs per year with a likely increase of 5%annually Tax rate is at 36%a) Develop a five year financial forecast showing profits before and after tax. b) Determine If the Loan should be given based on the forecast
arrow_forward
Sales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation.
Year
Sales
1
1,640
2
1,850
3
1,240
4
1,250
5
1,980
6
1,400
7
1,060
8
1,430
9
1,050
10
1,990
(Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your answer to 3 decimal places.)
What is your forecast for next year's sales? (Do not round intermediate calculations and round your answer to 2 decimal places.)
arrow_forward
Demand forecasting is the art and science of predicting future market demand.Select one:a. Trueb. False
arrow_forward
An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters.
Table 3
Quarter
Percent change in income
Percent Change in appliance sold
Quarter
Percent change in income
Percent Change in appliance sold
1
-2.3
-2.5
6
-1.0
1.0
2
-1.5
-1.0
7
0.7
1.4
3
2.8
7.4
8
5.2
3.4
4
0.5
2.6
9
-2.5
-0.5
5
4.6
8.5
10
1.7
1.8
1) What forecasting model should be used for this data.Why?
2) Develop the forecasting model that you have proposed in(a).
3) Compute the relationship for these data. In your opinion, is the relationship between independent variable strong enough to base a predictive the…
arrow_forward
Zeus Computer Chips, Incorporated used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the quad-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters:
QUARTER TWOYEARS AGO
DEMAND
QUARTER LASTYEAR
DEMAND
QUARTER THISYEAR
DEMAND
1
4,800
1
3,500
1
3,200
2
3,500
2
2,700
2
2,100
3
4,300
3
3,500
3
2,700
4
3,000
4
2,400
4
1,700
Use the regression and seasonal indexes to forecast demand for the next four quarters.
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
Period Forecast
1
2
3
4
arrow_forward
Which of the following scenarios is the most credible forecast over the next decade. (Choose ONLY 1 Scenario). Why?
Globalization of Business is Inevitable
IB Growth that is Less Global
Globalization and IB will Slow
arrow_forward
Amazon finds that sales in July are much greater relative to other months because of the Amazon Prime days in that month.
Assuming that an exponential smoothing model is used for forecasting sales, what should the company best do to make the forecast for the next month (Aug) more reflective of reality? Please pick from the provided options.
F t+1 = αDt + (1-α) Ft
increase value of alpha
decrease value of alpha
stay with the same alpha
decrease the expected forecast for the current month (Ft)
On hearing our forecast, our clients probe - how sure are we about the forecast? Which measure of errror (among those stated below) should we best use to respond?
a.
Root MSE (RMSE)
b.
Mean absolute percentage error (MAPE)
c.
Mean forecast error (Avg. error)
d.
Cumulative forecast error (CFE)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Related Questions
- An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. (Hint: Provides your answers in two decimal points)Table 1 Quarter % change in income % Change in appliance sold Quarter % change in income % Change in appliance sold 1 -2.3 -2.5 6 -1.0 1.0 2 -1.5 -1.0 7 0.7 1.4 3 2.8 7.4 8 5.2 3.4 4 0.5 2.6 9 -2.5 -0.5 5 4.6 8.5 10 1.7 1.8 (a) Identify which is the dependent variable and independent variable in this case. (b) Develop the forecasting model from this data. (c) Identify the nature of the relationship between two variables based on the data that you have here.arrow_forwardAn electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. (Hint: Provides your answers in two decimal points)Table 1 Quarter % change in income % Change in appliance sold Quarter % change in income % Change in appliance sold 1 -2.3 -2.5 6 -1.0 1.0 2 -1.5 -1.0 7 0.7 1.4 3 2.8 7.4 8 5.2 3.4 4 0.5 2.6 9 -2.5 -0.5 5 4.6 8.5 10 1.7 1.8 (a) What forecasting model should be used for this data. Why? (b) Develop the forecasting model that you have proposed in (a)arrow_forwardSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 455 2 510 3 518 4 570 5 590 a) Forecasted sales for year 6 using the trend projection (linear regression) method are 627.6627.6 sales (round your response to one decimal place). b) The MAD for a linear regression forecast is nothing sales (round your response to one decimal place).arrow_forward
- A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft = 6 + 4t. Over the past nine quarters, demand has been as follows: Period, t: 1 2 3 4 5 6 7 8 9 Demand: 11 15 17 22 28 32 36 39 43 Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t Demand MAD Tracking signal 1 11 2 15 3 17 4 22 5 28 6 32 7 36 8 39 9 43arrow_forwardDemand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.)arrow_forwardSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 455 2 510 3 518 4 570 5 590 a) Forecasted sales for year 6 using the trend projection (linear regression) method are nothing sales (round your response to one decimal place)arrow_forward
- Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 450 2 502 3 520 4 570 5 575 a) Forecasted sales for year 6 using the trend projection (linear regression) method aresales (round your response to one decimal place). b) The MAD for a linear regression forecast is nothing sales (round your response to one decimal place).arrow_forwardSales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 460 2 502 3 518 4 575 5 580 Part 2 a) Forecasted sales for year 6 using the trend projection (linear regression) method are enter your response here sales (round your response to one decimal place).arrow_forwardWhen a new business is started, or a patent idea needs funding, venture capitalists or investment bankers will want to see a business plan that includes forecast information related to profit and loss statements. What type of forecasting information do you think would the investors be looking for? Why?arrow_forward
- Given the demand data, answer the following questions below. Year Sales 1 - 123 2 - 118 3 - 109 4 - 112 5 -100 6 -110 7 -124 8 - ? What will be the forecast demand in Year 8 using Naïve method?a.) 120b.) 110c.) 115d.) 124arrow_forwardYou are getting into a business and want to take a loan. The bank requires that you show them your projected profits. Develop calculate a forecast for the next five years starting 2024 the following data: First order is for 100,000 units at a selling price of 6kshs per unit. Both numbers are projected to increase by 20% yearly Renting the production facility at 500,000kshs a year for five years Variable manufacturing cost of 1.50kshs per unit with a projected increase of 10% yearly Administration cost of 25,000kshs per year with a likely increase of 5%annually Tax rate is at 36%a) Develop a five year financial forecast showing profits before and after tax. b) Determine If the Loan should be given based on the forecastarrow_forwardSales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation. Year Sales 1 1,640 2 1,850 3 1,240 4 1,250 5 1,980 6 1,400 7 1,060 8 1,430 9 1,050 10 1,990 (Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your answer to 3 decimal places.) What is your forecast for next year's sales? (Do not round intermediate calculations and round your answer to 2 decimal places.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing