Question: I'm using excel with the x and y values in chart attached. (12 sets)Linear model with equation y=5961.2x-1E+07Then I have to figure the quadratic. Per

I'm using excel with the x and y values in chart attached. (12 sets)Linear model with equation y=5961.2x-1E+07Then I have to figure the quadratic. Per excel it came up with y=11.94x2 - 40725x + 3E+07**how well does the quadratic model fit the data. Is it a better fit than the linear model?ThenExponential modelExcel gave me y=2E-08e to the power of 0.0156xHow well does the exponential model fit the data? Is it a better fit than the linear or quadratic models?I'm then asked which regression model makes since to find out what the population would be in 20 years.

12550 Population Exponential 1910 131511 1920 237031 1930 280584 1940 306087 1950 375901 1920 471318 1870 538577 1980 584271 11 1890 636323 12 2000 715871 201 0.9856 Chart Title O O Population quadratic v- LLOP -3 . 15.0 23 O O O

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1 / 2 100% Math 104 Homework 6 Problem 1 Forecasting Revenues Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive...

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

6.1. Carbondale Company has the following credit policy 2/10, net 30. Carbondale also charges 1% per month interest on all accounts after 30 days. The following table shows the collection schedule of...

13. PLEASE HELP!!! Assignment Submission For this assignment, you submit answers by question parts. The number of submissions remaining for each question part only changes if you submit or change the...

Good Evening, Need help in completing tasks 1-3 (first attachment) Introduction I. Types of Errors There are two types of errors that we encounter as we perform experimental measurements. Systematic...

Accounting 5. Jacob tried to use a run-off procedure in Activity 3 to choose a movie from Four Star Videos Classics of the Week list wi

By accident, a large plate is dropped and breaks into three pieces. The pieces fly apart parallel to the floor. As the plate falls, its momentum has only a vertical component and no component...

Identify an option for an RRSP holder who de - registers their plan. a . Transfer to a Spousal RRSP if spouse has contribution room. b . Transfer funds to a Tax - Free Savings Account ( TFSA ) on non...

Repeat Programming Project 15.7 assuming a directed network. Programming Project 15.7 Create a limited airline scheduling system that will allow a user to enter city to-city connections and their...

The level of cholesterol in the blood for all men aged 20 to 34 follows a Normal distribution with mean M =188 milligrams per deciliter (mg/dl) and standard deviation M = 41 mg/dl. For 14-year-old...

Part 1: for a highly addictive substance such as cocaine, could the market demand for it ever be perfectly inelastic at all prices? Explain. Part 2: why do economists measure profit differently from...

Moissanite is a popular abrasive material because of its extreme hardness. Another important property of moissanite is elasticity. The elastic properties of the material were investigated in the...

The uniform bar of mass m is supported by the smooth pin at O and is connected to the cylinder of mass m 1 by the light cable which passes over the light pulley at C. If the system is released from...

will upvote immediately if answered asap Which of the following is NOT TRUE about why customer segmentation is important in strategy development? O Segmentation can inform a company about the fit of...

2. In this chapter, the reader should reflect on the following concepts: personal change competence, personal achievements, personal benchmarking, personal motivation strategy, personal mastery...

The tools are structured and for improving the individuals communication skills.

Always show respect for the other person or persons.