Which of trendline fits the data better and how can you tell

Assignment Help Applied Statistics

Reference no: EM131371366

Assignment: Regression Lines

Review the instructional video on how to use regression in Microsoft Excel.

Input your data into Microsoft Excel (data and years).

Create a scatter plot.

Insert a polynomial trendline with degree of 2. Make sure to show the equation and the R-square value. Also make sure you label each axis and give a title to your graph. Then repeat this process for a linear trendline in a new Microsoft Excel worksheet.

Answer the following questions in 175 to 260 words in the same Microsoft Excel worksheet as the graph:

• Which of the trendlines fits the data better? How can you tell?
• Compare and contrast the shape of the linear regression trendline with the shape of the quadratic.
• Which do you think will eventually grow faster? Thinking about the type of data you have, do you think your data will grow quickly over time?
• Which (lines or quadratics) has a minimum or maximum value? Thinking about the type of data you have, do you think your data has a minimum or maximum?

Reference no: EM131371366

Questions Cloud

Elements of supply chain management for manufacturing goods : What are the elements of supply chain management for manufacturing goods? Describe scheduling needs in high-volume,intermediate-volume systems and in job shop. What are GANTT charts and how are theyused for scheduling? Explain the relationship betwee..

Write a paper on a particular fire or explosion : The course project will consist of a 1,000-word research and analysis paper on a particular fire or explosion that resulted in a loss of life.

Develop a quantitative and qualitative research proposal : Given is article review.- Develop a Quantitative and Qualitative Research Proposal incorporating the specific methodologies covered.

Program that keeps track of the feeding of zoo animals : The program feed-animal should consume a structure that represents an animal and the name of a feeding time. It should switch the corresponding field in the animal structure to true.

Which of trendline fits the data better and how can you tell : Which of the trendlines fits the data better? How can you tell? Compare and contrast the shape of the linear regression trendline with the shape of the quadratic.

Develop the function all-fed : Develop the function all-fed. It consumes a list of animals, as defined in exercise 41.2.8, and modifies them so that their field for morning feedings is switched to true.

Describe some of the middle management responsibilities : Describe some of the middle management responsibilities for implementing TQM. What tasks do these individuals need to accomplish? How are middle management responsibilities different from executive management responsibilities?

Standard high school and college laboratories : What is considered to be the 'acceptable % error' for standard high school and college laboratories?

Consider the neutralization reaction : Consider the neutralization reaction that takes place when hydrochloric acid reacts with solid nickel(II) carbonate.

User Account

All Pages