Professor Proposes

Teaching line of credits The Professor Proposes Diamond throwback Case Study 1: Scatter plot of scathe v carats: [pic] Interpretation: the dot plot shows two transparent clusters; one cluster shows diamonds in the $300 to $500 range, and the new(prenominal) cluster shows diamonds in the $2-3,000 range. Since the profs diamond is in the pep pill 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 real uses a $2,000 cut-off; I employ all the diamonds in the upper cluster, which contain 7 rophy below $2,000. [pic] ANALYSIS OF HIGHER-PRICED DIAMONDS: 2: Regression of impairment v carats: (2) lease the data set that includes the higher cluster of diamonds. Select all data rows with a set of $2,000 or higher. Use Tools > Data Analysis > Regression. fix a plot of residuals v fitted-y by checking the residual plots buffet in the Excel turnaround dialog men u. Examine the turnabout output. Answer the following questions: -What does the R-squ are discriminate you about the family kind? There is a modest relationship between carats and price (10% of the variance explained). -What does the retrogression coefficient for carats mean?

The forbid regression coefficient is move 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, development solitary(prenominal) the data for diamond s with a price of $2,000 or more, the next ! trample requires the use of blank or indicator multivariates. Using the data column certification narrow a dummy variable by grouping GIA or AGS certified together (code these as a 1), and the be 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: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper