12 Aug Your company is considering entry into the diamond business
There are two parts of this assignment.
Use two entertainment files for the first part, instructions are in the word doc.
Part two:
Your company is considering entry into the diamond business. You gather information about how diamonds are marketed. You discover that diamonds are rated by PRICE, WEIGHT (carats), COLOR, DEPTH, CLARITY and the size of the TABLE. You obtain data on 30 diamonds (attached) and want to know what is the relationship between these variables. How is a diamond’s price influenced by its characteristics?
Perform a Correlation Analysis and a Multiple Linear Regression on the data. Use EXCEL functions and charts. The EXCEL data file has a data dictionary describing the meaning of the variables.
