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

A survey was conducted two years ago asking college students their top motivations for using a credit card. To determine whether this distribution has changed, you randomly select 425 college students and ask each one what the top motivation is for using a credit card. Can you conclude that there has been a change in the claimed or expected distribution? Use a = 0.05. Complete parts (a) through (d). New Survey Frequency, f 112 Response Old Survey % Rewards 28% 23% 22% 7% 97 Low rates Cash back Discounts Other 109 48 20% 59 a. State Hn and H, and identify the claim. What is the null hypothesis, H,? O A. The distribution of motivations is 28% rewards 23% low rate, 22% cash back, 7% discounts, and 20% other. O B. The distribution of motivations differs from the expected distribution. O C. The distribution of motivations is 112 rewards, 97 low rate, 109 cash back, 48discounts, and 59 other. What is the alternate hypothesis, Ha? O A. The distribution of motivations is the same as the…
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
Using the data from the table Disease or illness less than $35,000 $35,000 - 49,999 $50,000 - 74,999 $75,000 - 99,999 $100,000 or more Coronary heart disease 8.1 6.5 6.3 5.3 4.9 Stroke 3.9 2.5 2.3 1.8 1.6 Emphysema 3.2 2.5 1.4 1.0 0.8 Chronic bronchitis 6.3 4.0 4.4 2.2 2.4 Diabetes 11.0 10.4 8.3 5.6 5.9 Ulcers 8.7 6.7 6.5 4.7 4.4 Kidney disease 3.0 1.9 1.3 0.9 0.9 Liver disease 2.0 1.6 1.0 0.6 0.7 Chronic arthritis 33.4 30.3 27.9 27.4 24.4 Hearing trouble 17.2 16.0 16.0 16.2 12.4 Vision trouble 12.7 9.8 7.5 5.7 6.6 No teeth 11.6 7.8 5.5 4.2 4.1 A) create a line graph plotting Annual family income on the x-axis and prevalence of disease or illness on the y-axis. Include all data points for each disease on the same chart ( i.e.? plot the prevalence for each disease or illness as it's own line on a single chart) B) do any of the chronic disease in the table appear to have a dose-response relationship to annual family income? Justify your…
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
A study was done to look at the relationship between number of movies people watch at the theater each year and the number of books that they read each year. The results of the survey are shown below. Movies 10 7 6 10 0 9 1 6 Books 0 0 -0 0 9 0 9 -0 Use the model to predict the number of books read per year for someone who watches 3 movies per year.Books per year = (Please round your answer to the nearest whole number.) Interpret the slope of the regression line in the context of the question: The slope has no practical meaning since people cannot read a negative number of books. As x goes up, y goes down. For every additional movie that people watch each year, there tends to be an average decrease of 0.98 books read. Interpret the y-intercept in the context of the question: The y-intercept has no practical meaning for this study. If someone watches 0 movies per year, then that person will read 8 books this year. The best prediction for a person who doesn't watch…
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*****

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