Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $17.0 million each.Sales for these NCMS for the past two years were as follows: Use Exhibit 3.10.QUARTERLAST YEAR34QUANTITY(UNITS)17.233121Y=a. Find the equation of a simple linear regression line using Excel.Note: Round your answers to 3 decimal places.Last YearThis Year20.536 +QUARTERTHIS YEAR1234b. Compute trend and seasonal factor from a linear regression line obtained with Excel.Note: Do not round intermediate calculations. Round your answers to 3 decimal places.Period123412QUANTITY(UNITS)16293320340.7141Trend Forecast0.8001.0471.3670.8980.6641.1681.2920.762SeasonalFactors0.7321.1081.3300.8300.7321.1081.3300.830

QuarterLast yearQuantity (Units)Quarter This yearQuantity117116223229331333421420

Answered: Tucson Machinery, Incorporated,…

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

The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 99% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $818. The equation of the regression line is y = 1.451x - 40.698. Wages (state), x Wages (federal), y 713 760 785 805 851 870 921 926 947 985 1,002 1,045 1,091 1,145 1,185 1,239 1,281 1,307 1,320 1,400 Construct and interpret a 99% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $818. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) O A. We can be 99% confident that when the average weekly wages of state government employees is $818, the average weekly wages of federal government employees will be between $ and…
(3.) A system contains components connected in parallel as shown in the diagram. If all components operate inderentently, & each component has probability 0.45 of failing What is the minimum number of components that must be connected in parallel so that th Probability that the system operateds exceeds 0.9999? The minimun number of components that must be connected in parallel is.
Managers rate employees according to job performance and attitude. The results for several randomly selected employees are given below. Performance (x) / 10 / 5 / 6 / 6 / 9 / 3 / 3 / 4 / 5 / 9 Attitude (y) / 3 / 9 / 7 / 6 / 8 / 10 / 3 / 3 / 4 / 7 Use the given data to find the equation of the regression line. Enter the slope. (Round your answer to nearest thousandth.)
An instructor asked a random sample of eight students to record their study times at the beginning of a course. She then made a table for total hours studied (x) over 2 weeks and test score (y) at the end of the 2 weeks. The table is given below. Complete parts (a) through (f). x 10 13 10 18 6 15 16 21 y 93 79 81 74 85 81 85 80 a. Find the regression equation for the data points. b. Graph the regresson equation c. Describe the apparent relationship between the two variables. d. Identify the predictor and response variables. e. Identify outliers and potential influential observations. f.Predict the score for a student that studies for 17 hours.
I need help with this question
(please solve within 15 minutes I will give thumbs up)
Please solve what’s not filled in.
Which of the following is true of a linear regression line? a. Located as close as possible to all the points of a scatter chart. B. Is defined by an equation having 2 parameters: the slope and the intercept c. Provides an approximate relationship between the values of two parameters d. All of the above
Many small companies buy advertising without considering its effect. The marketing manager is trying to make the case that "you have to spend money to make money." Spending on billboard advertise ments, in the manager's opinion, has a direct effect on sales. These are records for 7 months in 1000s: Monthly expenditure on 21 25 billboards 16 42 34 10 19 Monthly sales Develop a regression estimating equation. If the monthly expenditure on billboards is 20,000/- what is the monthly sale generated 34 14 48 32 26 29 20
Solve the following using excel form
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 90% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $825. The equation of the regression line is y = 1.597x- 169.203. Wages (state), x Wages (federal), y 742 775 783 802 842 890 912 939 949 954 1,002 1,039 1,097 1,145 1,199 1,242 1,271 1,299 1,335 1,398 Construct and interpret a 90% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $825. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) O A. There is a 90% chance that the predicted average weekly wages of federal government employees is between S and S given a state average weekly wage of $825. O B. We can be 90%…
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 95% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $895. The equation of the regression line is y = 1.454x- 36.984. Wages (state), x Wages (federal), y 712 778 789 801 843 878 927 937 939 958 1,014 1,054 1,116 1,146 1,191 1,248 1,270 1,302 1,335 1,401 Construct and interpret a 95% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $895. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) O A. We can be 95% confident that when the average weekly wages of state government employees is $895, the average weekly wages of federal government employees will be between $ and…

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