Share
Explore BrainMass

# Regression Model: Chicken Data

Create a single linear regression model with Ave. Wt. as the dependent or response variable and Breed as the dependent or predictor variable. Make the breed Cobb the base or reference category.
a. What is the equation for this model?
b. What is the significance level of the model?
c. What are the P-values for the various coefficients?
d. Explain the meaning of the coefficient values.

e. Finally, Build your best regression model for Ave. Wt. using the variables in your data file. Do not include Count or Farm (They will only cause problems without contributing). Show the Excel Regression output for your final model. You do not need to show the output tables for intermediate models, but list the variables included, the Adjusted R Square and the Significance F.

PLEASE ATTACH ALL EXCEL FILES Also.

Count Ave. Wt. Age-Days Temp Flock Size Ave. Feed Consumption Breed Breed_BUTA Breed_Roff Farm
1 5.47 104 66 6,637 9.82 Cobb 0 0 Sunny Slope
2 5.63 110 67 8,152 11.29 Cobb 0 0 Pine Ridge
3 4.18 97 78 10,953 7.72 Cobb 0 0 West Rock Farm
4 5.25 100 66 9,123 10.3 Roff 0 1 Bowers' Spread
5 4.8 119 76 10,401 11.19 Cobb 0 0 Flat Top
6 5.84 104 56 11,144 11.3 Roff 0 1 Apple Creek
7 4.05 96 71 11,571 8.75 Roff 0 1 Mole Hill Farm
8 5.76 117 78 8,691 11.44 Cobb 0 0 Green Meadows
9 6.38 103 75 14,411 9.59 BUTA 1 0 Harper's
10 4.44 106 74 9,144 8.84 Roff 0 1 Willow Lake
11 6.61 113 67 8,571 10.96 BUTA 1 0 Hard Rock
12 4.44 104 76 10,028 8.55 Cobb 0 0 Clover Hill
13 5.25 99 63 11,751 9.27 Cobb 0 0 Bridgewater Farms
14 7.03 121 64 13,339 12.1 Cobb 0 0 KJ
15 6.62 105 69 11,191 10.5 BUTA 1 0 Spring Creek
16 6.66 116 76 8,397 10.46 BUTA 1 0 Singers' Glenn
17 4.1 96 63 10,637 9.9 Cobb 0 0 Hill & Dale
18 6.22 100 77 9,552 8.39 BUTA 1 0 W & W Poultry Farm
19 4.73 93 63 10,078 9.2 Roff 0 1 The Peak
20 4.83 114 56 10,933 9.71 Roff 0 1 Hemlock Road
21 6.39 112 75 10,811 10.86 BUTA 1 0 Cooper Stream
22 11.5 224 69 2,594 24.3 Cobb 0 0 Forest Hill Breeding Farm
23 4.32 105 81 10,884 9.77 Cobb 0 0 Brukeholder's
24 5.06 101 84 9,606 9.86 Cobb 0 0 RC
25 5.09 112 73 11,693 10.01 Cobb 0 0 Falling Rock
26 6.79 108 85 10,441 10.35 BUTA 1 0 East/West Meet
27 4.2 104 76 9,930 9.67 Roff 0 1 Carver's
28 6.38 102 61 9,672 9.07 BUTA 1 0 Bout Broke Farm
29 6.13 103 82 12,706 10.93 Cobb 0 0 12 Oaks
30 4.61 100 71 8,534 9.01 Cobb 0 0 A Peace of Heaven
31 6.85 108 65 9,238 11.84 BUTA 1 0 Winslow's
32 4.87 97 78 8,671 8.62 Cobb 0 0 Beulah Land
33 6.77 111 70 11,461 10.36 BUTA 1 0 Cedar Rail
34 4.69 100 73 6,945 9.15 Roff 0 1 Chaos Farm
35 4.96 100 79 10,898 9.65 Roff 0 1 Crooked Creek
36 6.54 103 56 11,764 9.01 BUTA 1 0 Double N
37 6.56 115 79 10,577 12.27 Cobb 0 0 Peaceful Mountain
38 5.39 95 69 11,063 7.94 Cobb 0 0 Rock Bottom Farm
39 10.91 203 77 1,616 23.6 Cobb 0 0 Rosewood Breeding Farm
40 6.85 113 67 10,714 10.54 BUTA 1 0 Steep Hollow

#### Solution Summary

The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.

\$2.19