Professor Proposes

Teaching line of credits The Professor Proposes Diamond relapse Case Study 1: Scatter plot of worth v carats: [pic] Interpretation: the dot plot shows two obvious clusters; one cluster shows diamonds in the $300 to $500 range, and the early(a) cluster shows diamonds in the $2-3,000 range. Since the profs diamond is in the upper range, we focus on this. manipulation $1800 as the cut-off point, in a higher place which you will include this data. Note: the case study cloth uses a $2,000 cut-off; I employ all the diamonds in the upper cluster, which contain 7 compulsive below $2,000. [pic] ANALYSIS OF HIGHER-PRICED DIAMONDS: 2: Regression of worth v carats: (2) lease the data set that includes the higher cluster of diamonds. Select all data rows with a charge of $2,000 or higher. Use Tools > Data Analysis > Regression. constitute a plot of residuals v fitted-y by checking the residual plots corner in the Excel turnaround dialog menu. Examine the fixation yield. Answer the following questions: -What does the R-squ are discriminate you about the family family? There is a modest relationship between carats and price (10% of the variance explained). -What does the regression coefficient for carats mean?

The forbid regression coefficient is surprise perhaps higher carat diamonds are lower in price for some reason not considered in this regression. -Is this regression coefficient material at the alpha = .01 take?: Yes. Regression output from analysis 2: [pic] [pic] (3) Again, victimization solitary(prenominal) the data for diamonds with a price of $2 ,000 or more, the next trample requires the! use of boob or indicator multivariates. Using the data column certification maintain a dummy variable by grouping GIA or AGS certified together (code these as a 1), and the rest codes set to 0. hold a regression using this dummy variable versus price. -What R-squared did you come upon? 56% -Is this certification dummy variable statistically significant? Yes How would you...If you want to get a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay