(USE ONLY EXCEL SHEET FOR DATA, FORMULAS, and the GRAPHS) For the following list of data (number of sold cars in every year), apply "exponential smoothing with trend" for all the years below. (i. e find the Forecast case1 use \alpha = 0.01 and \ including trend): beta = 0.3 - - - --- case2 use: for \alpha = 0.1 and \ beta = 0.05 Calculate MAD for both cases (5 %). . Decide which case values are better and why? (5 %) Assume trend is zero for the 2012 years. Year Number of sold cars 2012 107 2013 113 2014 150 2015 133 2016 151 2017 1 Based on least squared regression method find the projections for the years 2021, 2022, and 2023. Plot the number of sold cars versus years (points graph) and show the trend line based on your projections. (5%).

(USE ONLY EXCEL SHEET FOR DATA, FORMULAS, and the GRAPHS) For the following list of data (number of sold cars in every year), apply "exponential smoothing with trend" for all the years below. (i. e find the Forecast case1 use \alpha = 0.01 and \ including trend): beta = 0.3 - - - --- case2 use: for \alpha = 0.1 and \ beta = 0.05 Calculate MAD for both cases (5 %). . Decide which case values are better and why? (5 %) Assume trend is zero for the 2012 years. Year Number of sold cars 2012 107 2013 113 2014 150 2015 133 2016 151 2017 1 Based on least squared regression method find the projections for the years 2021, 2022, and 2023. Plot the number of sold cars versus years (points graph) and show the trend line based on your projections. (5%).

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 2AGP

See similar textbooks

Similar questions

Which are the graphs for quantitative data?
Hello! Please analyse the table 3 and 4 in the image attached. the data is supposed to see if there is a relationship between the prevalence of obesity(table3) or life expectancy (table4) between males and females. thank you!
PLEASE HELP I need to make a trend line for this data but I don't know how
Explain trend projection with regression?
The equation for yearly sales (in 000 dollars) for a commodity with year 2011 as originy = %3D 91.6 +28.8X. Determine the trend equation to give monthly trend values with Jan. 2012 as origin and calculate the trend for March, 2012.
make a regression analysis about any healthcare issue
List one possible confounding variable for this analysis and explain what impact it might have on the variables of interest.
What is a trend line that shows the most accurate relationship between x and y and is very close to most of the data points
You just used a scatterplot to examine the relationship between CO2 emissions and city fuel consumption for 502 vehicles that use regular fuel. Find the correlation between these two variables. Round to 3 decimal places. Please make sure you use the correct variables in the data set.
How does one do a trend analysis?
Over the past 100 days, the price of a certain stock went up on 60 days and went down on 40 days. Explain why these data should not be used to test the claim that this stock price goes down on less than half of the days.
The librarian at a local school collected data on the number of students using the library after school each week during the first 22 weeks of school. The librarian counted the number of students in the library each day and then calculated the total for each week. The weekly totals were plotted in a graph and then a trend line was fit to the data. Students in the Library 600 500 400 300 200 100 5 10 15 20 25 Week Number For which week does the trend line underpredict the number of students using the library by the greatest amount? A week 3 B week 5 C week 10 D week 22 Number of Students