TrendLinesCaseStudy (4)
.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
18
Uploaded by BrigadierHeat19682
MATH108X - Trend Lines Case Study
#1
#2
#3
#4
#5
Project Goal
: To learn how trend lines can be used as a powerful tool in the Quantitative Reasoning Process.
Begin by selecting a scenario that will use a scatterplot and trend line as the mathematical tool to make an informed decision. (Remember that we are looking for numerical/quantitative data where the scatterplot and trendline would show the relationship of an input and output variable). You may use the examples as a guide, but it is preferred that you use creativity to choose a scenario that is useful in your real world.
As best you can, list the key variables and assumptions you will be making in order to eventually make your informed decision. You should have exactly two key variables, an input variable and an output variable. Collect data (at least 15 points), report your source(s), make a scatterplot, and fit an appropriate trend line to the data in order to make your informed decision. Be sure to state which trendline best fits your data using the box provided and record your equation.
Make an informed decision using your scatterplot and trend line you created in Step 3. Write about your decision. Include a prediction you made using the trendline equation. Ensure your decision is well supported by your data and trend line.
Share your idea and data with at least two other people. Get feedback from them and mprove your project accordingly. Complete the Quantitative Reasoning Process by writing a short paragraph that details any changes you made after your reviewers helped you to evaluate your data and reasoning.
B
List your Scenario:
Write the background o
Trying to figure out if how mu
mileage
Background Story
selling a car
List you
Inp
of your scenario and the goals of your study.
Out
List you
1.
the higher
2.
lower amo
3.
there will b
uch I should sell my 2015 Honda Accord based o.n the
ur key variables
put Variable
thousand miles
tput Variable
price
ur key assumptions
r the amount of miles traveled the more cheeper the car
ount of miles traved the more expensive the car
be some outliers
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
Series forecasting for Business
In a regression model if you drop one insignificant variable then
Ol a.
R will increase and SSE also will increase.
O b. None
O c. R2will decrease and SSE also will decrease.
O d. R2will increase but SSE will decrease.
O e. R2will decrease but SSE will increase.
CLEAR MY CHOICE
IOUS PAGE
arrow_forward
Paraphrase this one. Analyze and elaborate in 85 words. Regression analysis data also helps you understand whether the relationship between two different variables can give way to potential business opportunities.
arrow_forward
Paraphrase this one. Analyze and elaborate in 200 words.
Why organizations use time series data analysis?
Time series analysis helps organizations understand the underlying causes of trends or systemic patterns over time. Using data visualizations, business users can see seasonal trends and dig deeper into why these trends occur. With modern analytics platforms, these visualizations can go far beyond line graphs.
When organizations analyze data over consistent intervals, they can also use time series forecasting to predict the likelihood of future events. Time series forecasting is part of predictive analytics. It can show likely changes in the data, like seasonality or cyclic behavior, which provides a better understanding of data variables and helps forecast better.
arrow_forward
Any thoughts and how this relates to marketing management
arrow_forward
Create a line graph for this set of monthly sales numbers.
Run a regression analysis.
What is the regression equation?
Is the regression equation significant? How can you tell?
What is the Rsquare? What does this signify?
What is the sales forecast for month 13?
1
550
2
548
3
546
4
549
5
550
6
548
7
551
8
551
9
552
10
551
11
553
12
553
arrow_forward
15) Which is not considered to be an OPSCM execution process byany of the most popular models?Select one:A. returnsB. manufacturing/production/makeC. logisticsD. procurement/acquisition/purchasingE. research & development16) Purchasing’s role is to get the lowest possible price oneverything needed by OPSCM.Select one:A. TrueB. False17) Which OPSCM macro designs / operations models /manufacturing environments use a forecast to plan for fulfillmentof demand?Select one:A. MTO & ETOB. MTO & MTSC. CTO & MTSD. ETO & MTSE. All of them use forecasts.
arrow_forward
Arnold Tofu owns and operates a chain of 12 vegetable protein “hamburger” restaurants in northern Chicago area. Sales figures and profits for the stores are in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Calculate a regression line for the data. What is your forecast of profit for a store with sales of $24 million? 30 millions?
Store
Sales
Profits
1
6
14
2
3
11
3
5
15
4
5
16
5
15
24
6
18
28
7
17
22
8
12
21
9
15
26
10
20
43
11
14
34
12
5
9
arrow_forward
What are the advantages and disadvantages of aggregating demand from a forecasting view? Are there other things that should be considered when going from multiple DCs to a DC?
arrow_forward
Descibe and analyze how the Trend Approach in data analysis is the monitoring of variables to see how they change over time and how they can be used to predict future variable values.
Discuss trend analysis in depth and the reasons companies rely on such strategy in their business operations. Discuss how Trend Analytics may encourage awareness and help a brand to grow. What are three examples of Trend Analysis that can be offered, that may help an organization gain a competitive edge in the industry in which it operates? Please utilize relevant Digital Marketing Analytics in the response.
arrow_forward
A forecaster is assessing two different models for demand. The output from each model and the actual
demand data appears in the table. Use MAD to compare the two models. Which model does a better job of
forecasting?
Demand Model 1
52
52
54
56
60
56
58
58
52
57
53
57
Model
2
21
55
54.7 51.9
54.5
52.0
53.8
55.8
59.6
56.4
52
53.5
53.5
55.5
56.5
57.5
57.8
58.0
58.0
56.0 52.6
56.3
56.6
55.0
53.4
O Model 2 is 9% better
O Model 1 is 8% better
O Model 2 is 15% better
O Model 1 is 5% better
arrow_forward
The table below summarizes September 20223 financial performance by two market segments. The dates highlighted in orange indicate occupancy higher than 90% Please find the correct statement about the data analysis based on the table. Market segment 1 shows pattern of peak on Weekdays. Market segment 2 shows a pattern of peak on Weekends. Based on the demand pattern, Market Segment 2 could be leisure travelers. Most guests in the market segment 2 are less price sensitive than those in the market segment 1.
arrow_forward
If Mr. Ishaq is the Director of Lexus Company in Nizwa, what does he need to do to predict customer sales or product demand?
a.
Forecasting
b.
Marketing
c.
Production
d.
Coordination
arrow_forward
1.) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects only in the data. Qtr1 = 1 if Quarter 1, 0otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise, Qtr3 = 1 if Quarter 3, 0otherwise. Based only on the seasonal effects in the data, compute estimates of quarterly sales for year 6.a. Report the estimate of sales for Year 6 Quarter 1. (Enter a whole value.)b. Report the estimate of sales for Year 6 Quarter 4. (Enter a whole value.)2.) Let Period t = 1 refer to the observation in quarter 1 of year 1; Period t = 2refer to the observation in quarter 2 or year 1; … and Period t = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and Period (t), develop an estimated regression equation to account for seasonal effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute the estimates of quarterly sales for year 6.a. Report the estimate…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Related Questions
- Series forecasting for Business In a regression model if you drop one insignificant variable then Ol a. R will increase and SSE also will increase. O b. None O c. R2will decrease and SSE also will decrease. O d. R2will increase but SSE will decrease. O e. R2will decrease but SSE will increase. CLEAR MY CHOICE IOUS PAGEarrow_forwardParaphrase this one. Analyze and elaborate in 85 words. Regression analysis data also helps you understand whether the relationship between two different variables can give way to potential business opportunities.arrow_forwardParaphrase this one. Analyze and elaborate in 200 words. Why organizations use time series data analysis? Time series analysis helps organizations understand the underlying causes of trends or systemic patterns over time. Using data visualizations, business users can see seasonal trends and dig deeper into why these trends occur. With modern analytics platforms, these visualizations can go far beyond line graphs. When organizations analyze data over consistent intervals, they can also use time series forecasting to predict the likelihood of future events. Time series forecasting is part of predictive analytics. It can show likely changes in the data, like seasonality or cyclic behavior, which provides a better understanding of data variables and helps forecast better.arrow_forward
- Any thoughts and how this relates to marketing managementarrow_forwardCreate a line graph for this set of monthly sales numbers. Run a regression analysis. What is the regression equation? Is the regression equation significant? How can you tell? What is the Rsquare? What does this signify? What is the sales forecast for month 13? 1 550 2 548 3 546 4 549 5 550 6 548 7 551 8 551 9 552 10 551 11 553 12 553arrow_forward15) Which is not considered to be an OPSCM execution process byany of the most popular models?Select one:A. returnsB. manufacturing/production/makeC. logisticsD. procurement/acquisition/purchasingE. research & development16) Purchasing’s role is to get the lowest possible price oneverything needed by OPSCM.Select one:A. TrueB. False17) Which OPSCM macro designs / operations models /manufacturing environments use a forecast to plan for fulfillmentof demand?Select one:A. MTO & ETOB. MTO & MTSC. CTO & MTSD. ETO & MTSE. All of them use forecasts.arrow_forward
- Arnold Tofu owns and operates a chain of 12 vegetable protein “hamburger” restaurants in northern Chicago area. Sales figures and profits for the stores are in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Calculate a regression line for the data. What is your forecast of profit for a store with sales of $24 million? 30 millions? Store Sales Profits 1 6 14 2 3 11 3 5 15 4 5 16 5 15 24 6 18 28 7 17 22 8 12 21 9 15 26 10 20 43 11 14 34 12 5 9arrow_forwardWhat are the advantages and disadvantages of aggregating demand from a forecasting view? Are there other things that should be considered when going from multiple DCs to a DC?arrow_forwardDescibe and analyze how the Trend Approach in data analysis is the monitoring of variables to see how they change over time and how they can be used to predict future variable values. Discuss trend analysis in depth and the reasons companies rely on such strategy in their business operations. Discuss how Trend Analytics may encourage awareness and help a brand to grow. What are three examples of Trend Analysis that can be offered, that may help an organization gain a competitive edge in the industry in which it operates? Please utilize relevant Digital Marketing Analytics in the response.arrow_forward
- A forecaster is assessing two different models for demand. The output from each model and the actual demand data appears in the table. Use MAD to compare the two models. Which model does a better job of forecasting? Demand Model 1 52 52 54 56 60 56 58 58 52 57 53 57 Model 2 21 55 54.7 51.9 54.5 52.0 53.8 55.8 59.6 56.4 52 53.5 53.5 55.5 56.5 57.5 57.8 58.0 58.0 56.0 52.6 56.3 56.6 55.0 53.4 O Model 2 is 9% better O Model 1 is 8% better O Model 2 is 15% better O Model 1 is 5% betterarrow_forwardThe table below summarizes September 20223 financial performance by two market segments. The dates highlighted in orange indicate occupancy higher than 90% Please find the correct statement about the data analysis based on the table. Market segment 1 shows pattern of peak on Weekdays. Market segment 2 shows a pattern of peak on Weekends. Based on the demand pattern, Market Segment 2 could be leisure travelers. Most guests in the market segment 2 are less price sensitive than those in the market segment 1.arrow_forwardIf Mr. Ishaq is the Director of Lexus Company in Nizwa, what does he need to do to predict customer sales or product demand? a. Forecasting b. Marketing c. Production d. Coordinationarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing