Question: The table below provides data from several line items from the North Dakota state budgets from 2003 2014. Each line item represents the number of

The table below provides data from several line items from the North Dakota state budgets from 2003 2014. Each line item represents the number of millions of dollars spent for that category in the given year. The final column on the data table is the population of North Dakota each year according the U.S. Census Bureau.

State of North Dakota

Year

budget line items

Population of the State

Higher Education

(in millions

of dollars)

Transportation

(in millions

of dollars)

Total Budget

(in millions

of dollars)

2003

230

385

2496

631,680

2004

240

397

2562

635,480

2005

272

452

2808

634,528

2006

292

501

2945

636,019

2007

305

446

3081

637,534

2008

326

450

3365

640,525

2009

390

593

4040

645,903

2010

406

654

4808

674,526

2011

377

846

5204

685,476

2012

389

911

5445

702,087

2013

505

1483

6482

724,019

2014

567

1897

7262

739,904

Part A: Construct a scatter-plot of the money spent on higher education versus the year. Be sure to put the

explanatory variable on the horizontal axis. Be sure to label each axis and include appropriate units of scale. If the data appear to follow a linear model, draw the regression line (line of best fit.) If the data appear to follow an exponential model, draw the regression curve (curve of best fit.) Include this graph in your report

Part B: Find the equation for the line or curve of best fit that you drew on the graph in question #1. Use this equation to predict the amount of money North Dakota will budget for higher education in 2020. In your report, discuss at least two reasons why this prediction may not turn out to be accurate.

Part C: Construct a scatter-plot of the money spent on transportation versus the year. Be sure to put the explanatory variable on the horizontal axis. Be sure to label each axis and include appropriate units of scale. If the data appear to follow a linear model, draw the regression line (line of best fit.) If the data appear to follow an exponential model, draw the regression curve (curve of best fit.) Include this graph in your report

.Part D: Find the equation for the line or curve of best fit that you drew on the graph in part C. Use this equation to predict the amount of money North Dakota will budget for transportation in 2020. In your report, discuss at least two reasons why this prediction may not turn out to be accurate.

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 Accounting Questions!