Diamond Regression Instructions and Data File

This exercise develops a multi-variable equation that estimates the market price of diamonds based on the
“4Cs” of diamond valuation: Carat, Color, Clarity, Cut.
Use the attached data file ABOVE. The data is from a very old edition of the Diamond Buyer’s Guide.
[ Add t for this exercise, but one can adjust for inflation by (1+average inflation rate)^(number of compounding
years) ]
Discussion and Suggested Approach
We have numeric and non-numeric data appearing in the first worksheet of the attached workbook.
Tables are provided to code the non-numeric data (substitute a number for a categorical variable) on the
second worksheet.
On the third worksheet, a blank coding table is provided with the first row already coded properly using the
“vlookup” function.
You may code this worksheet manually OR let Excel perform the “heavy lifting” by using the “vlookup” function.
Toggle it into formula view to function and its syntax. Note that the numeric data is referenced directly.
Regression Model
[A] Develop a regression equation using the data provided based on the “4Cs” and estimate the market price of
a diamond based on the parameters below (3 points):
Weight = 1.5 Carats
Color Grade: E
Clarity Grade: VS1
Cut Category: Good
[B] Determine what proportion of the total variation in the market price of diamonds that the model explains. (2
points)
[C] Determine which parameter you would eliminate if any if it was necessary to further refine the model. (1
point)

 

Sample Solution

Apart from the cost of capital and assets and liability composition, the size of the banking business is to be considered as a important determinant of the performance of the banks. The size of the banking business denotes the economies of scale .The bank with wide spread retail net work with branches in every nook and corner of the country denotes the large scale economy. But in such kind of the size of the bank the cost of maintaining many branches will be too high and this would definitely reduces the profitability of the banks. The banks in important cities perform better than the bank with too many branches. Income statement: The financial position is being revealed in the Balance Sheet. The method of operation can be clearly visualized in the income statement. The operating ratios would indicate the efficiency of management and the banks success for a particular period of time. By analyzing the income statement, one can assess the banks efficiency in controlling the costs and generating the income. Determinants based on income statements Control of costs The profitability of banking business can be increased by controlling the unnecessary costs. The closure of unprofitable branches or retail outlets would surely help in the reduction of costs. Timely collection of loan amount avoids the bad debts. Also the non-performance of certain assets would create maintenance costs upon which no revenue has been earned. Higher wages and salary will definitely increase the profits of the banks (Tunisia, Malaysia) Like the reduction of cost increases the profit, the increase of certain costs would definitely increase the profitability of the banking company. Payment of higher wages and salary to the employees would boost the moral of the employees and would be a great motivating factor for them. Their performance may be in high quality in the sense they can give better service to the customer with smile on their faces and the work may be finished in less than the standard time allotted. Lower payment of interest on deposits and higher revenue from loans – this wide disparity may lead to higher profitability of the banks. There exists wide disparity of interest earned and interest paid. The difference between the two is the profit for the banks. For deposits less interest is paid whereas the interest that is paid for loans and advances is too hi

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.