Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need these two questions step by step Q1: Wisconsin is an important milk-producing state. Some people might argue that because of transportation costs, the

i need these two questions step by step

Q1: Wisconsin is an important milk-producing state. Some people might argue that because of transportation costs, the cost of milk increases with the distance of markets from Wisconsin. Suppose the milk prices in eight cities are as follows. Cost of Milk Distance from Madison (per gallon) $2.64 (miles) 1,245 2.31 425 2.45 1,346 2.52 973 2.19 255 2.55 865 2.40 1,080 2.37 296 Use the prices along with the distance of each city from Madison, Wisconsin, to develop a regression line to predict the price of a gallon of milk by the number of miles the city is from Madison. Use the data and the regression equation to compute SSR, SST and SSE for this model. Sketch a graph. Comment on the slope. Predict the price when distance is 1,000 miles and 500 miles. Q2: The following data are the claims (in $ millions) for BlueCross BlueShield benefits for nine states, along with the surplus (in $ millions) that the company had in assets in those states. State Claims Surplus $277 Alabama $1,425 Colorado 273 100 Florida 915 120 Illinois 1,687 259 Maine 234 40 Montana 142 25 North Dakota 259 57 Oklahoma 258 31 as 894 141 Use the data to compute a correlation coefficient, r, to determine the correlation between claims and surplus.

Step by Step Solution

3.50 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

Answer Q1 Excel Data Data Analysis Regression SUMMARY OUTPUT Regression Statistics Multiple R 075377... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: James D. Stice, Earl K. Stice, Fred Skousen

17th Edition

032459237X, 978-0324592375

More Books

Students also viewed these Mathematics questions

Question

f. What subspecialties and specializations does the person list?

Answered: 1 week ago

Question

22. Why is tPA not helpful in cases of hemorrhagepg109

Answered: 1 week ago