EvTel is preparing to enter the smart home market. Thus, they are conducting market research in...

 

Transcribed Image Text:

EvTel is preparing to enter the smart home market. Thus, they are conducting market research in Istanbul. The company is planning to analyze the past 3 years' smart home device sales data with various forecasting methods to predict future sales. Help the company with the analysis by solving the questions below. Answers Smart Home Device Sales Orçun, the product manager of EvTel needs insight about the sales trends of the smart home market. He managed to find the past market sales data of some smart home oriented companies. Answer the following questions by using the table given. Part 1 Years Quarters Past Sales Q1 What is the difference between the saies of the first quarter of 2018 and the first quarter of 2019? Report a positive number What is the total sales at the end of 2020? 01 155.949,00 22 02 142.620,00 2018 Q3 What percentage of the total sales at the end of 2020, occurred in the second quarter of 2020? Part 2 Orçun needs you to fit 3 time-series; Linear, 3rd Degree Polynomial, and Power trendlines to the past quarterly sales of the smart home market. Q3 171.411.00 Q4 256.212,00 2018-Q3 Linear Q1 Q2 Q3 According to your trendlines, report the projected sales for the given periods and trendlines. 240.004,00 2019-Q1 3rd Degree Polynomial 270.351,00 2019-Q4 Power 2019 259.041,00 Find the difference between the estimated sales according to the 3rd Degree Polynomial and Power Trendlines for the first half of 2022. Report a positive number Q2 Q4 308.751,00 Q3 According to the Power Trendline, when will EvTel reach 14979808,0 total sales? Click Here 01 414.058,00 04 Decide which trendline has the best fit for the actual data Then, report the sales of the third quarter of 2021 for that method. 2020 Q2 546.812,00 art 3 Orçun asked you the following questions about forecasting methods and theory. For Polynomial Trendlines; the higher the degree is, the better forecasting results are. A better fit to the actual data guarantees better forecasts of the future. Q3 671.035,00 Q1 Click Here Q4 741.837,00 22 Click Here EvTel is preparing to enter the smart home market. Thus, they are conducting market research in Istanbul. The company is planning to analyze the past 3 years' smart home device sales data with various forecasting methods to predict future sales. Help the company with the analysis by solving the questions below. Answers Smart Home Device Sales Orçun, the product manager of EvTel needs insight about the sales trends of the smart home market. He managed to find the past market sales data of some smart home oriented companies. Answer the following questions by using the table given. Part 1 Years Quarters Past Sales Q1 What is the difference between the saies of the first quarter of 2018 and the first quarter of 2019? Report a positive number What is the total sales at the end of 2020? 01 155.949,00 22 02 142.620,00 2018 Q3 What percentage of the total sales at the end of 2020, occurred in the second quarter of 2020? Part 2 Orçun needs you to fit 3 time-series; Linear, 3rd Degree Polynomial, and Power trendlines to the past quarterly sales of the smart home market. Q3 171.411.00 Q4 256.212,00 2018-Q3 Linear Q1 Q2 Q3 According to your trendlines, report the projected sales for the given periods and trendlines. 240.004,00 2019-Q1 3rd Degree Polynomial 270.351,00 2019-Q4 Power 2019 259.041,00 Find the difference between the estimated sales according to the 3rd Degree Polynomial and Power Trendlines for the first half of 2022. Report a positive number Q2 Q4 308.751,00 Q3 According to the Power Trendline, when will EvTel reach 14979808,0 total sales? Click Here 01 414.058,00 04 Decide which trendline has the best fit for the actual data Then, report the sales of the third quarter of 2021 for that method. 2020 Q2 546.812,00 art 3 Orçun asked you the following questions about forecasting methods and theory. For Polynomial Trendlines; the higher the degree is, the better forecasting results are. A better fit to the actual data guarantees better forecasts of the future. Q3 671.035,00 Q1 Click Here Q4 741.837,00 22 Click Here

Answer rating: 100% (QA)

To Construct a trendline in microsoft excel Select the X and Y axis as shown in below table Select scatter graph with markers in the insert tool bar D... View the full answer