Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The file below contains quarterly data on pork sales. Price is in dollars per hundred pounds, quantity sold is in billions of pounds, per capita

The file below contains quarterly data on pork sales. Price is in dollars per hundred pounds, quantity sold is in billions of pounds, per capita income is in dollars, U.S. population is in millions, and GDP is in billions of dollars. Do all work in Excel with StatTools and EXPLAIN EVERY STEP.

A. Use the data to develop a regression equation that could be used to predict the quantity of pork sold during future periods. Determine what variables should be included in the model. Discuss how you can tell whether unequal variance or multicollinearity might be a problem.

B. Suppose that during each of the next two quarters, price is 45, U.S. population is 240, GDP is 2620, and per capita income is 10,000. (These are in the units described previously.) Predict the quantity of pork sold during each of the next two quarters and provide a 95% prediction interval.

image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ A } & B & C & D & E & F \\ \hline 1 & Quarter & Pork Sales & Pork Price & Income & Population & GDP \\ \hline 2 & 1 & 30.44 & 39.35 & 8255 & 212 & 1549 \\ \hline 3 & 2 & 29.23 & 46.11 & 8671 & 213 & 1589 \\ \hline 4 & 3 & 25.12 & 58.83 & 8583 & 214 & 1629 \\ \hline 5 & 4 & 28.35 & 52.20 & 8649 & 215 & 1669 \\ \hline 6 & 5 & 28.95 & 47.99 & 8775 & 216 & 1718 \\ \hline 7 & 6 & 27.83 & 49.19 & 8812 & 217 & 1768 \\ \hline 8 & 7 & 29.53 & 43.88 & 8884 & 218 & 1818 \\ \hline 9 & 8 & 35.90 & 34.25 & 8967 & 219 & 1868 \\ \hline 10 & 9 & 32.94 & 39.08 & 9036 & 220 & 1918 \\ \hline 11 & 10 & 31.86 & 40.87 & 9125 & 221 & 1978 \\ \hline 12 & 11 & 30.74 & 43.85 & 9280 & 222 & 2038 \\ \hline 13 & 12 & 34.99 & 41.38 & 9399 & 223 & 2098 \\ 14 & 13 & 32.43 & 47.44 & 9487 & 224 & 2148 \\ \hline 15 & 14 & 32.65 & 47.84 & 9530 & 225 & 2218 \\ \hline 16 & 15 & 31.58 & 48.52 & 9622 & 226 & 2288 \\ \hline 17 & 16 & 35.40 & 50.05 & 9732 & 227 & 2338 \\ \hline 18 & 17 & 33.98 & 51.98 & 9813 & 228 & 2398 \\ \hline 19 & 18 & 37.58 & 48.04 & 9778 & 229 & 2448 \\ \hline 20 & 19 & 38.59 & 38.52 & 9809 & 230 & 2478 \\ \hline 21 & 20 & 43.47 & 36.39 & 9867 & 231 & 2508 \\ \hline 22 & 21 & 41.24 & 36.31 & 9958 & 231 & 2539 \\ \hline 23 & 22 & 43.00 & 31.18 & 9805 & 235 & 2598 \\ \hline 24 & 23 & 37.57 & 46.23 & 9882 & 235 & 2598 \\ \hline \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Payroll Accounting 2022

Authors: Bernard J. Bieg, Judith A. Toland

32nd Edition

0357518756, 9780357518755

More Books

Students also viewed these Accounting questions