Question: Question 8 1 pts The attached data file contains monthly rider data for Amtrack. Amtrak.xlsx Use this data to create an Excel Forecast Sheet. What

Question 8 1 pts The attached data file contains monthly rider data for Amtrack. Amtrak.xlsx Use this data to create an Excel Forecast Sheet. What is value of the Root Mean Square Error (RMSE) statistic? (Enter your answer to 2 decimal places) Month Jan-91 Feb-91 Mar-91 Apr-91 May 21 Jun-91 Ju-91 Aug-91 Sep-91 Oct-91 Nov-91 Dec-91 Jan 92 Feb-92 Mar-92 Apr-2 May 02 Jun-92 JU-92 Aug-92 Sep 92 O-92 Nov-92 Dec-92 Jan- Feb- Mar93 Ape-93 May 30 Jun-89 J0-99 Aug 30 Sep-3 O. Now 93 Deo 93 Jan-94 Feb Mar 04 Apr-94 May-04 Jun - Aug 04 54-64 Oct 04 Now-94 Dec 14 Jan Feb 95 Mar-05 Amtrak Ridership Number of er of Passengers Ridership in thousands) 1709 1621 1973 1812 1975 1862 1940 2013 1596 1725 1676 1814 1615 1557 1891 1958 1885 1623 1903 1997 1704 5810 1862 1875 1705 1619 1837 1957 1917 1882 1933 1996 1673 1753 1720 1734 1543 1574 1903 1834 1831 1776 1866 1907 1686 1770 1775 1783 1548 1697 179 MacBook Air 00 Di DD Fa FS F6 F7 FE $ % A & ww Apr-95 May-95 Jun-95 Jul-95 Aug-95 Sep-95 Oct-95 Nov.95 Dec-95 Jan-96 Feb-96 Mar-96 Apr-96 May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 May-97 Jun-97 Jul-97 Aug-97 Sep-97 Oct-97 Nov-97 Dec-97 Jan-98 Feb-98 Mar-98 Apr-98 May.98 Jun-98 Jul-98 Aug-98 Sep-98 Oct-98 Nov-98 Dec-98 Jan-99 Feb-99 Mar-99 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 1733 1772 1761 1792 1875 1571 1647 1673 1657 1382 1361 1559 1608 1697 1693 1836 1943 1551 1687 1576 1700 1397 1372 1708 1655 1763 1776 1934 2008 1616 1774 1732 1797 1570 1413 1755 1825 1843 1826 1968 1922 1670 1791 1817 1847 1599 1549 1832 1840 1846 1865 1986 1949 1607 1804 1850 1836 DOC-99 Jan-00 Feb-00 Mar-00 Apr-00 May-00 Jun-00 Jul-00 Aug-00 Sep-00 Oct-00 Nov-00 Dec-00 Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 Oct-01 Nov-01 Dec-01 Jan-02 Feb-02 Mar-02 Apr-02 May-02 Jun-02 Jul-02 Aug-02 Sep-02 Oct-02 Nov-02 Dec-02 Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Jan-04 Feb-04 Mar-04 1836 1542 1617 1920 1971 1992 2010 2054 2097 1824 1977 1981 2000 1683 1663 2008 2024 2047 2073 2127 2203 1708 1951 1974 1985 1760 1771 2020 2048 2069 1994 2075 2027 1734 1917 1858 1996 1778 1749 2066 2099 2105 2130 2223 2174 1931 2121 2076 2141 1832 1838 2132

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Do you agree with Ron Parkers statement To be successful, you must also be willing to run at problems/opportunities when everyone else is running away from them?

Can some one help me I know how to do some of it just not all of it. ASAP please. can someone help without charging extra. im already paying to use the this site. Interest rate 5% term 5 years...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

With the file NP_EX19_10a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the...

please send me the solution of this question as soon as possible. please see the table below and solve the question and upload the photos of solutions if not able to upload excel sheet . this is...

PROJECT STEPS 1 . Lucia Campos and three friends own a small business called Corvallis Group Restore, an upcycling business in Corvallis, Oregon, that sells useful and attractive products made from...

Use Microsoft Excel to answer all the questions below. Please upload one single Excel solution file on Blackboard by the due date, with each question answered on separate sheet of the same Excel...

Question 2 1 pts A customer service representative has a target of resolving an issue in under 4 mins. They achieve their target for 90% of issues. In a shift, they handle 110 independent issues....

PROJECT STEPS 1 . Roshana Haddad is a financial analyst for Peak Partners, a full - service recruiting agency with headquarters in New York City and offices in five other U . S . cities. Roshana asks...

In this project, you will find and discern the appropriate data to determine a realistic assessment of the weighted average cost of capital for a firm of your choosing. You will need to search for...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Determine the mole fraction of argon that ionizes according to the reaction Ar Ar+ + e- at 10,000 K and 0.35 atm (KP = 0.00042 for this reaction).

The function A defined by is called the Airy function after the English mathematician and astronomer Sir George Airy (18011892). (a) Find the domain of the Airy function. (b) Graph the first several...

Learning Objective 5 Learning Objective 6 Question Content Area Problem 12-21 (Algorithmic) (LO. 5, 6) Zebra, Inc., a calendar year S corporation, incurred the following items this year. Sammy is a...

What is an example of constructive feedback? provide reference