A statistical program is recommended.A company that sells musical instruments has been in business for five years. During that time, sales of pianos increased from 12 units in the first year to 76 units in the most recent year. The firm'sowner wants to develop a forecast of piano sales for the coming year. The quarterly sales data follow.Year Quarter 1 Quarter 2 Quarter 3 Quarter 4123454711121824forecast for quarter 2forecast for quarter 3forecast for quarter 43910145713514162235Total YearlySales1229355076(a) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: x₁ = 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter2, 0 otherwise; and x3 = 1 if quarter 3, 0 otherwise. (Let t = 1 denote the time series value in quarter 1 of year 1; t = 2 denote the time series value in quarter 2 of year 1; ... and t = 20 denotethe time series value in quarter 4 of year 5. Round your numerical values to two decimal places.)(b) Compute the quarterly forecasts for next year. (Round your answers to the nearest integer.)forecast for quarter 1pianospianospianospianos

YearQuarter 1Quarter 2Quarter 3Quarter 4Total Yearly…

Answered: A statistical program is recommended. A…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

You’ve come across research explaining the recent credit bubble by obesity. The research provided a strong correlation as proof that the credit bubble was in fact caused by people gaining weight, as seen in the following chart. Critically evaluate the research findings and point out any potential problems with the methodology.
C8. According to the Pew Research Center (2015), recent immigrants are better educated than earlier immigrants to the United States. The change was attributed to the availability of better education in each region or country of origin. The percentage of immigrants 25 years of age and older who completed at least high school is reported in this table for 1970 to 2013. Write a statement describing the change over time in the percentage who completed at least a high school degree. 1970 1980 1990 2000 2013 Mexico 14 17 26 30 48 Other Central/South America 57 53 60 66 Asia 75 72 75 82 84 48 68 81 87 95 Europe 36 48 52 58 72 Caribbean 81 91 88 85 85 Africa Source: Pew Research Center, Modern Immigration Wave Brings 59 Million to U.S., Driving Population Growth and Change Through 2065, 2015. Retrieved from https://www.pewresearch.org/hispanic/2015/09/28/modern- immigration-wave-brings-59-million-to-u-s-driving-population-growth-and-change-through-2065/ 52
In order to advise students properly, a college advisor is interested in the relationship between a student's GPA and the number of hours the student an average weck. The data are shown in the table. Study Time (in hours) 33 Student GPA 3.2 19 16 2.4 31 3.1 5. 24 2.7 28 2.9 7 1.7 34 3.3 14 2.2 10 35 3.4 11 1.8 Part 1 of 5 (a) Let I represent study time and let y nepresent GPA. Graph the points. Grade Point Average vs. Weekly Study Time Weckly Study Time (hours) Part 2 of 5 (b) Does there appear to be a linear trend? Yes Part: 2/5 Part 3 of 5 (c) use the data points (16, 2.4) and (34, 3 3) to find an eguation of the line through these points. Express numbers as decimas or integers. Write answer in slope-intercept form (y = MI+ b). The equation is GPA
The following statistics represent weekly salaries at a construction company. Mean $620 First quartile $485 Median $540 Third quartile $600 Mode $535 94th percentile $683 The most common salary is $ The salary that half the employees' salaries surpass is $ The percent of employees' salaries that surpassed $600 is The percent of employees' salaries that were less than $485 is %. The percent of employees' salaries that surpassed $683 is %. If the company has 100 employees, the total weekly salary of all employees is $ %.
There are two underlying assets in an asset pool. Each has a 2.8 percentchanges of failing. You own an asset that will pay $1 unless both assets fail. Graph theprobability of your asset not paying as the correlation between the two input assets runsfrom 0.5 to 0.98. For what levels of correlation is the output asset investment grade
Charlie Corporation's managers in the stamping department have been studying the overhead cost and the relationship with machine hours. The following are data from the most recent 12 months. Month Overhead Machine hours January 5,030 2,730 February 1,600 600 March 7,210 3,403 April 4,560 2,200 May 6,880 3,411 June 6,520 2,586 July 6,230 3,364 August 5,570 2,411 September 7,728 3,960 October 5,810 2,897 November 4,580 2,207 December 6,010 2,864 The manager of the department has requested a regression analysis of these two variables. The staff person performing the analysis decided to exclude February. She observed the volume of activity was very low for that month because of two factors: a severe flue outbreak and an electrical fire that disrupted operations for about 10 working days. Required: c. Using the least square (regression) analysis, compute the fixed cost. d. Using the least square (regression) analysis, how much are the estimated overheads for…
Fully explain the issues and problems with the below correlational data. Focus on the data in the highlighted box versus the rest of the data. Do not try to explain the data, but rather focus on the statistical issues and problems. IF YOU CAN'T SEE THE IMAGE HERE. PLEASE GO TO THIS LINK Linke 10 6. 8. 7. 5. 4. 10 20 30 40 50 60 70 80 90 100 Age Enjoyment of Hip-Hop
A poll uses responses everal questions to calculate a "Happiness" index that measures overall happiness. An article included the happiness index for the 7 years between 2008 and 2016. Also included in the article were the percentages of people who responded "somewhat agree" or "strongly agree" to the following statements. Statement 1 (happy with life) 1: At this time, I'm generally happy with my life. Statement Year 2008 2009 2010 2011 2013 2015 2016 2 (won't benefit): I won't get much benefit from the things that I do anytime soon. Happiness Index 36 36 34 32 36 33 30 Happy with Life Statement (percentage somewhat or strongly agree) 82 83 78 79 83 80 82 Won't Benefit Statement (percentage somewhat or strongly agree) 31 37 35 39 39 37 42 (a) Calculate the value of the correlation coefficient for Happiness index and the response to the Happy with life statement. (Round your answer to four decimal places.) 0.8321 x (b) Calculate the value of the correlation coefficient for Happiness…
Does the background music affect the behavior of supermarket shoppers? An experiment to answer this question was conducted in a supermarket during the relatively stable summer shopping months. Two days were selected in midweek. One day was assigned to receive no background music. During the second day slow-tempo background music was played. The daily sales (in dollars) for twelve weeks are shown in the accompanying table. None Slow tempo $15,172 $15,917 15,485 16,110 13,922 13,818 12,204 14,709 15,501 13,982 14,106 16,416 14,608 14,727 12,946 14,823 15,002 14,825 14,670 15,949 16,202 15,488 13,286 13,055 Estimate the difference in the actual average daily sales between no-music days versus slow-tempo days using a 95% confidence interval. Does the data suggest that, on the average, background music positively affects daily sales? Show all necessary work.
The number of adult Americans who smoke continues to drop. The table contains estimates of the percentages of adults (ages 1818 and over) who were smokers in the years between 1965 and 201715.and 201715. ???? ?Year � ??????? ?Smokers � 1965 41.94 1970 37.4 1974 37.1 1978 34.1 1980 33.2 1983 32.1 1985 30.1 1987 28.8 1990 25.5 1993 25.0 1995 24.7 1997 24.7 1999 23.5 2001 22.8 2002 22.5 2004 20.9 2006 20.8 2008 20.6 2010 19.3 2012 18.1 2014 16.8 2017 14.0 According to your regression line, how much did smoking decline per year during this period, on the average? Give your answer to three decimal places. average smoking decline: percentage points
A psychologist believed that as children get older, they engage in more “inactive activities” such as playing computer games, watching TV and surfing the internet. She collected data from 10 children. She recorded the age of each child and the amount of activity (in hours) the child engaged in per week. Age Activity 7 4.3 9 3.2 10 1 13 1.5 12 1.2 15 0.8 9 3 12 4 15 1.5 14 1.9 Using excel, obtain a scatterplot of the data. Discuss the relationship between age and activity based on the scatterplot. Using excel, obtain the simple linear regression linear regression line predicting activity from age. Interpret the intercept and slope of the regression line. By hand, predict the amount of activity for age = 14. By hand, calculate the residual for age = 14 Using excel output, test the null hypothesis that the slope coefficient is zero using the p-value approach. Write one sentence interpreting the meaning of this result. Make sure to report the test statistic…
Please answer the following question ****EXCEL*****

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS