Fit the trend effects using the data

Assignment Help Basic Statistics
Reference no: EM131996612

Can you please help me with this HW question?

Use the charting tool in Excel to develop a regression model to fit the trend effects using the data below for this scenario.

The "Economic Report to the President of the United States" included data on the amounts of manufacturers' new and unfilled orders in millions of dollars. Shown here are the figures for new orders over a 21-year period:

Year

Total Number of New Orders

1 55,022

2 55,921

3 64,182

4 76,003

5 87,327

6 85,139

7 99,513

8 115,109

9 116,251

10 121,547

11 123,321

12 141,200

13 162,140

14 168,420

15 171,250

16 176,355

17 195,204

18 209,389

19 237,025

20 272,544

21 293,475

What is required is first a linear model (chart) and then a polynomial (order 2) model (chart) using the above data, and each chart must show the line formula and the r-squared value.

The charts then should be used to answer the following questions:

How well does either model fit the data?

Which model should be used for forecasting?

And provide explanations using the relevant metrics.

Reference no: EM131996612

Questions Cloud

Animal rights foundation : A certain medical organization tends to oppose the use of meat and dairy products in our? diets, and that organization has received hundreds of thousands
How do you determine monthly profit for 20 stores : How do you determine monthly profit for 20 stores with variables such as store size, student population, advertising etc. by using linear regression?
Sample size sufficient to reduce sampling risk : As per SA 530, the auditor shall determine a sample size sufficient to reduce sampling risk to an acceptably low level.
Different offices of the telephone company : Your client has provided you with preliminary data to examine. You have a sample of 20 cases reported by two different offices of the telephone company.
Fit the trend effects using the data : Use the charting tool in Excel to develop a regression model to fit the trend effects using the data below for this scenario.
Three measures of central tendency : 1. Compare AND contrast the three measures of central tendency: mean, median and mode. Is there a "best" measure of central tendency?
What values can the correlation coefficient take on : What values can the correlation coefficient take on? What is our interpretation of these values?
Party affiliation and gender follows : The makeup of the US Senate by party affiliation and gender follows:
After viewing this sample of running times : After viewing this sample of running times, one of the coaches commented that the quarter milers turned in the more consistent times.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Find the probability that the truck driver

Find the probability that the truck driver goes more than 575 miles in a day. (Round your answer to three decimal places.)

  Old process by carrying out a x2 test of goodness-of-fit

Investigate the hypothesis that the breakage rate for the new process is the same as the rate for the old process by carrying out a X2 test of goodness-of-fit.

  Compute the hazard rate function of x when x is uniformly

compute the hazard rate function of x when x is uniformly distributed over 0

  Association of pesticides and the occurrence

For this assignment there are four given examples. From these examples identify which bias is occurring and support your reasoning.

  Probability of one-time fling

This is called a one-time fling. About 10% of all adults deliberately do a opne-time fling and feel no guilt about it!

  Find the current percentage of customers who click on ads

Suppose an internet marketing company wants to determine the current percentage of customers who click on ads on their smartphones.

  Distinguish among the effects of culture

1. Why is it so hard to distinguish among the effects of culture, race, and ethnicity in our research?

  Appropriate confidence interval

Conduct the test in (a) using an appropriate confidence interval.

  The monty hall problem

Suppose there are three doors, labeled A, B, and C. A new car is behind one of the three doors, but you don't know which. You select one of the doors

  Analyse data from a recent observational study of ageing

What analyses you performed - your description of the results should be sufficiently clear that the reader could reproduce your results

  A sample of 40 children with chronic bronchitis are studied

peak expiratory flow pef is a measure of a patientotildes ability to expel air from the lungs. patients with asthma or

  Compute confidence interval for the mean amount charges

Give a 99% confidence interval for the mean amount charges would have increased if this benefit had been extended to all such customers.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd