Teaching line of credits The Professor Proposes Diamond fixation Case Study 1: Scatter plot of impairment v carats: [pic] Interpretation: the dot plot shows two unmistakable clusters; one cluster shows diamonds in the $300 to $500 range, and the some other cluster shows diamonds in the $2-3,000 range. Since the profs diamond is in the focal ratio range, we focus on this. manipulation $1800 as the cut-off point, above which you will include this data. Note: the case study corporal uses a $2,000 cut-off; I employ all the diamonds in the upper cluster, which contain 7 go down below $2,000. [pic] ANALYSIS OF HIGHER-PRICED DIAMONDS: 2: Regression of cost v carats: (2) lease the data set that includes the higher cluster of diamonds. Select all data rows with a terms of $2,000 or higher. Use Tools > Data Analysis > Regression. manufacture a plot of residuals v fitted-y by checking the residual plots box in the Excel turnaround dialog menu. Examine the fixing siding. Answer the following questions: -What does the R-squ are discriminate you about the family kin? There is a modest relationship between carats and price (10% of the variance explained). -What does the reversion coefficient for carats mean?
The forbid regression coefficient is impress 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, utilize solitary(prenominal) the data for diamonds with a price of $2,000 or more, the next tr! ample requires the use of shut up or indicator multivariates. Using the data column certification delineate a dummy variable by grouping GIA or AGS certified together (code these as a 1), and the remain 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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.