I DO NOT NEED A PAPER WRITTEN I DO NEED THE QUESTIONS I AM ASKING ANSWERED TO BE

Question

I DO NOT NEED A PAPER WRITTEN

I DO NEED THE QUESTIONS I AM ASKING ANSWERED TO BE GIVEN TO ME THOUGH

I NEED THE NUMBERS FOR THE 2 AND 3 PERIODS, I NEED THE TRENDING AND EXPONENTIAL SMOOTHING NUMBERS

AGAIN, NOT ASKING FOR A PAPER TO BE WRITTEN SO PLEASE DO NOT LECTURE ME LIKE THE LAST TWO ANSWERS THAT WERE COPIED AND PASTED

I AM PAYING CHEGG TO ANSWER THIS QUESTION

I WAS VERY EXPLICIT IN THE ANSWERS I NEED

PLEASE DO NOT WASTE YOUR TIME OR MINE BY JUST GIVING ME WHAT THE LAST 3 PEOPLE DID

READ THE ENTIRE POST AND AT THE END, I CLEARLY STATE THE ANSWERS I AM LOOKING FOR

DONT TELL ME THERE IS NOT A MODEL THAT CAN BE USED, JUST GIVE ME THE NUMBERS..PLEASE

Forecasting Case Study: New Business Planning

Important Note: Students must access the “Entrepreneurship and the U.S. Economy” page of the Bureau of Labor Statistics website in order to complete this assignment.

Scenario

The generation of new business start-up is vital to the growth of the economy as it builds new jobs and creates new opportunities for the community. The Bureau of Labor Statistics tracks new business development and jobs created on the website for the United States Department of Labor. You have been tasked with forecasting economic growth and decline patterns for new businesses in the United States.

Forecasting

Access the “Entrepreneurship and the U.S. Economy” page of the Bureau of Labor Statistics website. Under the "Business establishment age" heading, the first chart reviews new businesses less than 1 year old during the March 1994 to March 2015 period. Click on the [Chart data] link below the chart:

Once the chart data window opens, you will see the number of establishments that are less than 1 year old for each year during this period:

Using the five most recent years and the "Forecasting Template" spreadsheet provided, complete the forecasts for the next two periods and provide updated Totals and Average Bias, median absolute deviation (MAD), mean squared error (MSE), and mean absolute percentage error (MAPE) for all four charts. Provide a Summary Page in Excel with a 500-750 word report on the analysis completed by the forecasting models. Include review of error, recommendations on the best forecasting model to use, and analysis of the business trend data for new business startup in the United States.

I don’t need a paper written, just the answers to the questions they are asking about.

There is also an excel form that has multiple folders that role into each other. I could not post it with this because chegg would not accept it. I wrote below what inputs I need to make on each form on my end if you could supply the answers in orange boxes I can input on my excel file

2period moving average            need demand for periods 1,2,3,4,5

3period moving average        need demands for periods 1,2,3,4,5

Expotential smoothing           need demands for period 1,2,3,4,5 and alpha and forecast

Trend adjusted exp smoothing need demands for periods 1,2,3,4,5 , and alpha value and beta value, smoother forecast Ft and smoothed trend Tt

Explanation / Answer

Chart 1. Number of establishments less than 1 year old, March 1994–March 2015 Time Year Number of Establishments Forecast The difference between Forecast and Original Y Mean Squared Error 1 1994 5,69,419 634597 65178 4248123767 2 1995 6,04,415 635459 31044 963731864 Intercept 3 1996 6,09,638 636321 26683 712005421 Slope 4 1997 6,39,114 637184 -1930 3725563 5 1998 6,43,070 638046 -5024 25238295 6 1999 6,50,730 638909 -11821 139744892 7 2000 6,74,644 639771 -34873 1216124436 8 2001 6,71,383 640633 -30750 945536490 9 2002 6,59,236 641496 -17740 314713931 10 2003 6,62,543 642358 -20185 407425335 11 2004 6,53,887 643221 -10666 113771687 12 2005 6,79,925 644083 -35842 1284647709 13 2006 7,15,734 644945 -70789 5011023604 14 2007 7,03,834 645808 -58026 3367038170 15 2008 6,78,095 646670 -31425 987517210 16 2009 6,08,769 647533 38764 1502617622 17 2010 5,60,588 648395 87807 7710071133 18 2011 5,82,569 649257 66688 4447343945 19 2012 6,31,817 650120 18303 334992781 20 2013 6,29,078 650982 21904 479794270 21 2014 6,52,780 651845 -935 874963 22 2015 6,79,072 652707 -26365 695113017 23 653569 1586871641 MSE 24 654432 25 655294 26 656157 27 657019 Forecasting The recommendation of the best forecasting method would be to use Linear Regression. Since the business data is given, and the year wise information can be found, it's best to use regression. The enterprenurship and US Economy chart explains the number of establishments that are less than one years old. It typically looks into the data and as a forecaster, I used the intercept function to calculate the known Ys, and the Known Xs. Also calcuate the slope based on the Known Ys, and Xs. Based on calculation of the Intercept and Slope--one can predict the simple regression equation Five Year Forecast The time series is given numbers. The forecast is extended further to next five years that is tabulated as 23, 24, 25. 26. and 27. Forecast is calculated for five years. Mean Squared Error The mean squared error shows the line of best fit\

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.