onsider the 'Diamond' dataset. It is provided as Microsoft Excel Workbook. Data are for 308 round-cut diamonds, taken from a newspaper ad. The codes are as follows: IDNO - an identification number for each data point. WEIGHT - weight of the diamond, in carats. COLOR - degree of colour purity in the diamond: "D" represents top colour purity grade; Lesser grades are "E", "F", and so on, through the alphabet. Note that these grades are ranked and should be coded according to their order. CLARITY - diamond clarity (presence or absence of minute flaws): "IF" means "internally flawless" - the top grade; "VVS1" and "VVS2" for "very very slightly imperfect"; and, "VS1" and "VS2" for "very slightly imperfect". Note that these grades are ranked and should be coded according to their order. RATER - the diamond was evaluated by one of three independent rating agencies: "GIA" - Gemmological Institute of America (based in New York); "IGI" - International Gemmological Institute (Antwerp); "HRD" - Hoge Raad Voor Diamant (Antwerp). PRICE - in Singapore dollars.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Consider the 'Diamond' dataset. It is provided as Microsoft Excel Workbook. Data are for 308 round-cut diamonds, taken from a newspaper ad. The codes are as follows:

  1. IDNO - an identification number for each data point.
  2. WEIGHT - weight of the diamond, in carats.
  3. COLOR - degree of colour purity in the diamond: "D" represents top colour purity grade; Lesser grades are "E", "F", and so on, through the alphabet. Note that these grades are ranked and should be coded according to their order.
  4. CLARITY - diamond clarity (presence or absence of minute flaws): "IF" means "internally flawless" - the top grade; "VVS1" and "VVS2" for "very very slightly imperfect"; and, "VS1" and "VS2" for "very slightly imperfect". Note that these grades are ranked and should be coded according to their order.
  5. RATER - the diamond was evaluated by one of three independent rating agencies: "GIA" - Gemmological Institute of America (based in New York); "IGI" - International Gemmological Institute (Antwerp); "HRD" - Hoge Raad Voor Diamant (Antwerp).
  6. PRICE - in Singapore dollars.

 

PLEASE REFER TO THIS LINK ALL DATA INSIDE THIS https://files.fm/u/ef7g9uvqx

 

3.2. A fourth argument is that diamond weight is not the sole predictor of diamond price. Diamond colour and clarity are also significant predictor or diamond price. Provide statistical evidence to prove or disprove that argument.

 

PLEASE REFER TO THIS LINK ALL DATA INSIDE THIS https://files.fm/u/ef7g9uvqx

 

For all answers above, be sure to include relevant SPSS output (graphs, tables) to support your solutions (screenshots must include the time and date of your work).

You should interpret, discuss and report your answers. You should proceed if any of the assumptions is violated. However, you must report it.

 

PLEASE SHOW ME THE PROPER WAY HOW TO WRITE WHEN INSIDE THE SPSS AND ALSO THE DATA OR OUTPUT.

 

Expert Solution
Step 1

The objective is to test whether not only the diamond weight but also diamond color and clarity are also significant predictors on diamond price.

From the data, there are 6 variables Idno, Weight, color, clarity, rater and price.

Here, diamond price is a dependent variable. Weight, color ,clarity and rater are the independent variables.

The multiple regression equation for predicting diamond price is,

diamondprice=a+b1weight+b2color+b3clarity+b4rater

a is the constantb1  is the coefficient of weightb2 is the coefficient of colorb3 is the coefficient of clairty andb4 is the coefficient of rater

steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman