RFascenelli_Assignment5

Find four years weighted moving average? Forecast for 2019 with weights 1,4,2, ….. , Also find MAPE?                                                                                                                                               (10   Year   Cost   2013   18   2014   21   2015   18   2016   16   2017   20   2018   24   2019   ?

week demand (tons) 1 1174.5 2 1316.2 3 1197 4 1127.3 5 1193.1 6 1260.7 7 1378.2 8 1273.7 9 1366.4 10 1113 11 1177.7 12 1056 13 1291.2 14 1269.1 15 1289.6 16 1181 17 1249 18 1212 19 1286.2 20 1204.8 21 1266.2 22 1332.4 23 1236.3 24 1266.1 25 1415.3 26 1100.1 27 1208.1 28 1505.1 29 1282.7 30 1190.5 31 1152.8 32 1089.7 33 1404.7 34 1308.6 35 1255.4 36 1106.7 37 1484.6 38 1317.4 39 1294.7 40 1154 41 1449.9 42 1174.9 43 1466.9 44 1282.4 45 1228 46 1174 47 1196.2 48 1443.8 49 1309.1 50 1250.8 51 1222.8 52 1409.9 53 1147.3 54 1342.7 55 1220.3 56 1211 57 1293.3 58 1256.6 59 1303.2 60 1204.9 61 1129.1 62 1481.5 63 1230.2 64 1264.1 65 953.7 66 1248.9 67 1172.2 68 1253.5 69 1393.7 70 1245.2 71 995.8 72 1211 73 1319.4 74 1282.2 75 1257.5 76 1309.5 77 1153.7 78 1148.4 79 1346.8 80 1298.2 81 1294.8 82 1387.5 83 1119.3 84 1195.8 85…

Predict the annual salary in dollars for a mathematics instructor with 10 years of experience.Number of Years 7  9  6  7  11  12  11  3  3  7  9  1Salary (in Dollars) $48,897.00  $62,866.00  $54,585.00  $56,611.00  $53,541.00 $53,541.00  $47,027.00  $47,970.00  $46,668.00   $48,029.00   $46,735.00 $45,000.00

People who are severely obese (BMI ≥40) are at most risk for serious health problems, which are the most expensive to treat. The percent of people in a country who are severely obese from 2000 and projected to 2030 is shown in the table. Year 2000 % Severely Obese 2.6 Complete parts (a) through (c) below. 2010 4.7 2015 6.5 2020 2025 7.9 9.2 2030 11.4 a. Find the linear function that models severe obesity, with x equal to the number of years after 2000 and y equal to the percent of severe obesity in the country. y = X+ (Type an integer or decimal rounded to three decimal places as needed.)

If it cost $8 to fill a gas tank in 1980, how much would it have cost to fill the same tank in 1990? Average Gasoline Prices (per gallon) Price as a Percentage Price Index (1980 = 100) 25.4 Year Price of 1980 Price 1960 $0.31 25.4% 1970 $0.36 $1.22 $1.23 $1.56 $2.84 29.5% 29.5 1980 1990 100.0% 100.0 100.8% 100 8 127.9 2000 2010 127.9% 232.8% 232.8 It would have cost $ in 1990. (Round to the nearest cent as needed.)

What is the forecast for March using a 3-month moving average? Month Actual Demand November 20 25 December January February March 28 37 25

Market Weekly Gross Revenue ($100s) Television Advertising Newspaper Advertising Mobile 101.3 5.0 1.5 Shreveport 51.9 3.0 3.0 Jackson 74.8 4.0 1.5 Birmingham 126.2 4.3 4.3 Little Rock 137.8 3.6 4.0 Biloxi 101.4 3.5 2.3 New Orleans 237.8 5.0 8.4 Baton Rouge 219.6 6.9 5.8 Can I get this all done on excel if possible with step by step instruction thank you!

Market Weekly Gross Revenue ($100s) Television Advertising Newspaper Advertising Mobile 101.3 5.0 1.5 Shreveport 51.9 3.0 3.0 Jackson 74.8 4.0 1.5 Birmingham 126.2 4.3 4.3 Little Rock 137.8 3.6 4.0 Biloxi 101.4 3.5 2.3 New Orleans 237.8 5.0 8.4 Baton Rouge 219.6 6.9 5.8

Illustration 8.4. Show the data of Table 8.3 eliminating the different units of measurements.

how to calculate the residual value? Service Subscriptions Web Page Hits Adv Price 1 37.95 588.9 13.2 35.1 2 37.66 585.3 13.2 34.7 3 37.55 566.3 19.8 34.8 4 38.78 642.9 17.6 35.1 5 37.67 624.2 17.6 34.6 6 38.23 603.9 15.4 34.8 7 36.9 571.9 11 34.7 8 38.28 584.3 28.6 35.3 9 38.95 605 28.6 35.1 10 39.27 676.3 17.6 35.6 11 38.3 587.4 17.6 34.9 12 38.84 576.4 22 35.4 13 38.14 570.8 17.6 35 14 38.39 586.5 15.4 35.5 15 37.29 544 11 34.9 16 39.15 611.1 24.2 35 17 38.29 643.3 17.6 35.3 18 38.09 635.6 19.8 34.8 19 37.83 598.9 15.4 35.1 20 39.37 657 22 35.3 21 37.81 595.2 15.4 35.1 22 37.42 520 19.8 35.1 23 38.83 629.6 22 35.3 24 38.33 680 24.2 34.7 25 40.24 651.2 33 35.8

Country Birth rate GNP Growth Income ratio Bangladesh 47 140 0.3 2.3 Tanzania 47 280 1.9 3.2 Sierra Leone 46 320 0.4 3.3 Sudan 47 380 -1.3 3.9 Kenya 55 380 2.9 6.8 Indonesia 35 530 4.1 3.4 Panama 30 1910 3.1 8.6 Chile 25 2560 0.7 3.8 Venezuela 35 4220 2.4 4.9 Turkey 33 1540 3.5 4.9 Malaysia 31 1840 4.3 5 Nepal 44 150 0 4.7 Malawi 56 200 2.7 2.4 Argentina 20 2560 1.9 3.6   Test for the joint significance of the coefficients on growth and the income ratio.                 What other possible explanatory variables do you think it might be worth investigating?

Interpolation and extrapolation Estimate the production for the year 2005 with the help of the following table: Year production (m. tonnes) 1980. 20 1985. 22 1990. 26 1995 30 2000 35 2005. ? 2010. 43

Country Birth rate GNP Growth Income ratio Bangladesh 47 140 0.3 Tanzania 47 280 1.9 Sierra Leone 46 320 0.4 47 380 -1.3 55 380 2.9 35 530 4.1 30 1910 3.1 25 2560 0.7 35 4220 2.4 33 1540 3.5 31 1840 4.3 0 44 150 56 200 2.7 Argentina 20 2560 1.9 Sudan Kenya Indonesia Panama Chile Venezuela Turkey Malaysia Nepal Malawi 2.3 3.2 3.3 3.9 6.8 3.4 8.6 3.8 4.9 4.9 5 4.7 2.4 3.6 a. Using the data above, estimate a single regression model of the birth rate explained by GNP or the growth rate or the income ratio. Comment upon: i. the sizes and signs of the coefficients, ii. the significance of the coefficients, b. Write and explain your model? c. What other possible explanatory variables do you think it might be worth investigating?

Hours Spent in Child Care 7.5 1.8 0.9 8.0 5.2 6.1 3.3 1.0 4.4 1.6 5.2 11.5 11.6 10.1 9.0 7.3 2.2 1.0 5.2 10.7 7.6 4.1 10.1 6.0 10.1 9.9 10.4 7.0 3.8 9.6 4.1 7.2 4.0 8.5 6.0 7.3 5.4 11.5 9.1 6.5

Salary              ERA                         J. Santana 17.0 2.53 C. Lee 4.0 2.54 T. Lincecum 0.4 2.62 C. Sabathia 11.0 2.7 R. Halladay 10.0 2.78 J. Peavy 6.5 2.85 D. Matsuzaka 8.3 2.9 R. Dempster 7.3 2.96 B. Sheets 12.1 3.09 C. Hamels 0.5 3.09

Year Quarter Price 2010 1 263600 2010 2 264100 2010 3 259500 2010 4 248900 2011 1 251400 2011 2 259200 2011 3 251400 2011 4 252000 2012 1 272300 2012 2 258600 2012 3 265500 2012 4 291200 2013 1 290500 2013 2 302400 2013 3 322900 2013 4 331000 2014 1 324700 2014 2 344400 2014 3 327500 2014 4 355400 2015 1 347200 2015 2 341000 2015 3 330800 2015 4 370300 2016 1 350800 2016 2 380000 2016 3 368600 2016 4 371100 2017 1 372500 2017 2 386300 2017 3 385500 2017 4 409700 2018 1 408000 2018 2 423400 2018 3 404300 Predictive Analytics: Time-Series Forecasting:   The above contains data on median home prices in the West Census region quarterly from 2010 to2018. Easter Realtor, Inc. is interested in houses in this region. They want to use this data toforecast home price in the fourth quarter of 2018. For cross-validation, use the training set fromthe first quarter of 2010 to the fourth quarter in 2016, and use a validation set…

If it cost ​$12 to fill a gas tank in 2000​, how much would it have cost to fill the same tank in 1990​? Average Gasoline Prices (per gallon) Year Price Price as a Percentage of 2000 Price Price Index ​(2000=​100) 1960 ​$0.31 19.9​%   19.9   1970 ​$0.36 23.1​%   23.1   1980 ​$1.22 78.2​%   78.2   1990 ​$1.23 78.8​%   78.8   2000 ​$1.56 100.0​%   100.0   2010 ​$2.84 182.1​%   182.1

2.5 2.0 15 1.0 0.5 Incarcerated Americans 1920-2014 Prison Jail 0 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 Year Juvenile Detention 6. Describe the trend depicted in this ch 7. What impact do you think this trend has had on the public defender system? depic

Use tables to express and represent the descriptive statistics for thevariables below.   Years GDP growth (annual %) Gross capital formation (annual % growth) Labor force participation rate, total (% of total population ages 15-64) (modeled ILO estimate) 2019 0.892 2.556 71.38 2018 1.89 3.862 70.44 2017 0.997 6.158 71.15 2016 1.375 -0.103 70.31 2015 0.921 -6.13 68.74 2014 0.69 3.84 68.39 2013 0.518 5.473 68.53 2012 -0.614 -5.75 67.42 2011 1.73 8.972 67.63 2010 -1.457 -2.039 67.84 2009 -4.345 -18.427 68.15 2008 -0.8117 -8.009 68.46

Which of the following best completes the proof showing that AWXZ ~ AXYZ? Y Z 2.5 We 10 Since x7 L VWY angles WZX and XZY are both right angles and congruent. The proportion shows the corresponding sides are proportional, so the triangles are similar by the SAS Similarity Postulate.

C10. Exercise 3 used GSS data on the number of hours worked per week for a sample of 32 Latino adults. a. Calculate the mean number of hours worked per week. b. Compare the value of the mean with those you have already calculated for the median. Without constructing a histogram, describe whether and how she distribution of weeks worked per year is skewed.

Suppose admission to a movie cost $7.50 in 2005. What was its price in 1979 dollars? Assume that all prices have risen at the same rate as the CPI. The price was about $ in 1979. (Round to the nearest cent.) Average Annual Consumer Price Index (CPI) (1982- 1984=100) Year CPI Year CPI Year CPI 1976 56.9 1989 124.0 2001 177.1 1977 60.6 1990 130.7 2002 179.9 2003 184.0 1978 65.2 1991 136.2 1992 1979 72.6 140.3 2004 188.9 1980 82.4 1993 144.5 2005 90.9 1994 148.2 2006 2007 1981 1982 96.5 1983 99.6 1984 103.9 1985 107.6 1995 152.4 1996 156.9 2008 1997 160.5 2009 1998 163.0 2010 1986 109.6 1999 166.6 2011 1987 113.6 2000 172.2 2012 1988 118.3 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6

Year Percent Year Percent 1920 50.5 1980 19.3 1930 47.5 1990 16.4 1940 41.8 2000 17.5 1950 43.2 2010 23.6 1960 33.4 2020 27.4 1970 22.3 2030 28.1 Print Done Check A The table below gives the percent of men 65 years or older in the workforce for selected years from 1920 and projected to 2030. Complete parts a and b below. Click to view the table of the percentages. a) With x=0 representing 1900, find the cubic function that models the data. Report the model with coefficients to six decimal places. y= MI PU

Coca-Cola Revenues ($ millions), 2014 to 2019 Quarter  2014 2015 2016 2017 2018 2019 Quarter 1 10.58 9.94 10.28 9.12 7.63 8.02 Quarter 2 12.57 11.63 11.54 9.70 9.42 10.00 Quarter 3 11.98 11.77 10.63 9.08 8.78 9.51 Quarter4  10.87 10.13 9.41 7.51 5.36 9.07 What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.) Use the regression equation to make a prediction for each quarter in 2020. (Enter your answers in millions rounded to 3 decimal places.)

Monthly Sales 6267.19 7058.06 7119.5 7147.18 7198.52 7298.09 7325.7 7335.68 7355.97 7481.05 7490.23 7530.08 7616.09 7682.69 7684.14 7704.12 7704.98 7779.28 7798.23 7815.15 7844.16 7890.21 7977.6 7993.16 8021.03 8028.37 8068.86 8082.42 8096.17 8119.25 8129.21 8190.68 8255.28 8282.44 8376.31 8392.4 8400.95 8451.16 8456.66 8505.35 8539.25 8543.65 8573.05 8641.78 8667.48 8751.08 8777.97 8800.08 8888.65 8907.03 9096.87 9241.74 9411.68 9450.73 9484.62 9514.57 9521.4 9524.91 9733.44 10123.24 If you view the company’s performance record as a representative sample of its overall sales performance, and considering what you know about normal distribution, what is the dollar value for the lowest 25th percentile?

Year Number of Polio Cases (thousands) 1988 350 1992 138 1996 32 2000 2. 2005 3.2 2007 1.3

LAB WORK (EXCEL) US Industrial Production Index Level (Federal Reserve) Federal Funds Rate (Effective) Date McDonald's Corp FED IP 30-Jan-09 27-Feb-09 31-Mar-09 30-Apr-09 29-May-09 30-Jun-09 31-Jul-09 31-Aug-09 30-Sep-09 30-Oct-09 30-Nov-09 31-Dec-09 59.53 0.15 88.50 56.21 0.22 87.20 53.31 0.18 86.50 55.19 0.15 85.70 55.01 0.18 85.50 58.25 0.21 86.70 57.07 0.16 87.80 55.79 0.16 88.40 55.92 0.15 88.60 58.02 0.12 89.10 62.72 0.12 89.60 62.32 0.12 90.50 From the given data of stock price of McDonald's Corp (S), US Federal Funds Rate (FED), and US Industrial Production Index (IP), provide the answer the following questions - a. Generate mean, median, mode, standard deviations, variance, range, minimum and maximum values for all the three variables of interest. Also give your interpretations. b. Generate the correlations matrix from MS excel and interpret the results. c. Get the excel results for Multiple Regression assuming McDonald's Corp share price (S) as dependent variable and FED and…

prepare a line graph and examine the relationship observe between the two countries   Years                Growth rate         Unemployment rate %   Trinidad and Tobago Japan Trinidad and Tobago Japan 2016 -5.6 0.8 3.2 3.1 2017 -3.0 1.7 3.3 2.8 2018 0.1 0.6 3.0 2.2 2019 -1.2 0.3 3.76 2.4 2020 -7.8 -5.8 6.74 2.94

ASK YOUR TEACHER PRACTICE ANOTHER   The table shows the total personal income in the United States (in billions of dollars) for selected years from 1960 and projected to 2024. Year Income ($ billions) Year Income ($ billions) 1960 411.5 2008 12,100.7 1970 838.8 2014 14,728.6 1980 2307.9 2018 19,129.6 1990 4878.6 2024 22,685.1 2000 8429.7     These data can be modeled by an exponential function. Write the equation of this function, with x as the number of years past 1960 and y as the total personal income in billions of dollars. (Round your numerical values to three decimal places.)y = 812580.292

Prepare index Numbers of price for three years with average price as base from the data given below : RATE PER RUPEE COMMODITIES C A B 4 kg. 3 kg. 10 kg. 1st year 3금 kg. 3 kg. 9 kg. 2nd year 2 kg. 9 kg. 3 kg. 3rd year