Please answer B Through E if possible.

Development and Interpretation Configure the regression tool to include the "4C's. INPUT Options: Perform a regression and inculde the column labels from the data table. OUPUT Options: Set the ouput on a New Worksheet Ply named Regression + Specify all residual options and the normal probability plot. Using Yellow highlight highlight the cells that you referenced in your regression report to answer the questions below. [A] Linear Equation -- Develop a regression equation using the data provided based on the "4Cs" and estimate the market price of a diamond based on the parameters below (1 points + 2 for follow-on Q): Weight = 1.5 Carats Color Grade: E Clarity Grade: VS1 Cut Category: Good Use Excel to perform the above sumproduct computation. [B] Fit -- Determine the error and what proportion of the total variation in the market price of diamonds that the model's selected regression variables explain. (2 points) [C] Statistical Significance -- Determine which regression variables are statistically significant and determine which one (parameter) you would eliminate, if any, if it was necessary to further refine the model. (3 points) [D] Residual Analysis -- Determine which sample observation represents the best value from the buyer's perspective and the largest windfall from the seller's perspective (when sold). (2 points) [E] Statistical Inference --Detemine if the model developed from this set of sample data could be applied to the general population. Submission Part A (Step 2): Use the first link below to validate and interpret your model. (Max 10 points per above) Part B (Step 3): Once you are satisfied with your model, attach your worksheet using the second link below for the balance of credit. (Max 5 Points) Data from Diamond Buyer's Guide Price Carat 0.3 Color I Clarity Cut VVS1 Very Good Ideal $511.00 0.3 E VS2 $781.00 0.3 D VS2 Ideal $839.00 0.3 F VVS1 Ideal 0.3 E VVS1 Ideal 0.5 E SI2 Ideal 0.5 D SI1 Ideal 0.5 E VS2 Ideal $971.00 $1,130.00 $1,263.00 $1,604.00 $1,844.00 $2,026.00 $2,714.00 $5,899.00 $6,445.00 $6,892.00 0.5 G G VVS2 Ideal 0.5 E VVS2 Ideal 1 H VS1 Ideal 1 H VVS2 Ideal 1.01 G VS2 Ideal 1.01 G VS1 Ideal $7,308.00 1.01 D IF Ideal 2 2 K SI2 $17,716.00 $8,620.00 $10,264.00 N K VS2 N I SI1 2 m SI2 $11,751.00 $ 16,092.00 $27,080.00 2 E Very Good Very Good Premium Very Good Very Good Premium Very Good Very Good Very Good VS1 3 K SI2 3 3 ) SI1 $14,305.00 $17,905.00 $29,396.00 3.01 G SI1 3 3 F VS2 $42,881.00 $112,079.00 3.01 D IF Good Regression Encoding Grade IF 1 Color Grade D 1 E 2 F 3 Clarity Grade 1 Vvsi 2 VVS2 NA 1 Cut Ideal Premium Very Good Good Fair 3 2 G 4 VS1 4 st 3 . 5 5 5 4 VS2 S11 I 6 Poor 5 7 SI2 K 8 11 500 va 8 L 9 12 9 M 10 13 10 N 11 0 12 Ez odce 13 Q 14 15