Many regions along the coast in North and South Carolina and Georgia have experienced rapid population...

60.1K

Verified Solution

Question

Basic Math

Many regions along the coast in North and South Carolina andGeorgia have experienced rapid population growth over the last 10years. It is expected that the growth will continue over the next10 years.

The director gathered the following sample information.

FamilyFoodIncomeSize
1$3.84$73.981
24.0854.902
35.7653.204
43.4852.021
54.2065.702
64.8053.644
74.3279.743
85.0468.584
96.12165.605
103.2464.801
114.80138.423
123.24125.821
137.2077.587
146.4094.155
156.60135.768
165.40141.303
176.0036.905
185.4056.884
193.3671.821
204.6869.483
214.3254.362
225.5287.665
234.5638.163
245.4043.747
255.9062.406
(a-1)

Develop a correlation matrix. (Round your answers to 3decimal places. Negative amounts should be indicated by a minussign.)

FoodIncome
  Income     
  Size          
(b-1)Determine the regression equation. (Round your answersto 3 decimal places. Leave no cells blank - be certain to enter "0"wherever required.)
  The regression equation is: Food=  +  Income +  Size.
(b-2)

How much does an additional family member add to the amountspent on food? (Round your answer to the nearest dollaramount.)

  Another member of the family adds $  tothe food bill.
(c-1)What is the value of R2? (Roundyour answer to 3 decimal places.)
(c-2)

State the decision rule for 0.05 significance level.H0: ?1 = ?2 = 0;H1: Not all ?i's are 0.(Round your answer to 2 decimal places.)

  SourceDFSSMSFp
  Regression                    
  Error            
  Total        
(c-3)Complete the ANOVA (Leave no cells blank - be certainto enter "0" wherever required. Round SS, MS to 3 decimal placesand F to 2 decimal places.)
(d-1)

Complete the given below table. (Leave no cells blank -be certain to enter "0" wherever required. Do not round theintermediate calculations. Round T to 2 decimal places and allother values to 3 decimal places.)

  PredictorCoefSE CoefTP
  Income                        
  Size                        

Answer & Explanation Solved by verified expert
4.2 Ratings (730 Votes)
Correlation matrix is Food Income Income 0214 1 Size 0911 0127 Using excal to find correlation we have command correlarray1select income column array2 select food column Excel Output is SUMMARY OUTPUT Regression Statistics Multiple R 0916257008 R Square 0839526904 Adjusted R Square 0824938441 Standard Error 0460007547 Observations 25 ANOVA df SS MS F    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students