Preview

Data Analysis About Diamond Prices

Satisfactory Essays
Open Document
Open Document
17600 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Analysis About Diamond Prices
ECONOMETRIC MODEL FOR DIAMOND PRICES
This assignment is about to make an econometric model for diamond prices. I already have been studied the procedure to make an econometric model. I will make an econometric model and collect data to do estimation and later will check its BLUEness by apply diagnostic check. Hope I will come up with a BLUE model.
As we know diamond prices depends on the size, shape, color and clarity of the diamond. So I can write it as follow:
Diamond prices = ʄ (size, shape, color, clarity)
Size is in carats and it’s a quantitative variable but shape, color and clarity all are qualitative variables. All these qualitative variables have different groups in them, so to make an econometric model we will make dummies of all those groups of qualitative variables.
Diamond shapes => round, marquise, oval, emerald cut, pear, princess/radiant, trillion and heart.
Color scale => D, E, F, G, H, I, J, K, L and M.
Diamond clarity => VVS1, VVS2, VS1, VS2, SI1, SI2.
Now I will make dummy variable of these groups.
Diamond prices = β0+ β1SZ+ β2DR+ β3DO+ β4DE+ β5DP+ β6DPR+ β7DT+ β8DH+ β9Dd+ β10De+ β11Df+ β12Dg+ β13Dh+ β14Dj+ β15Dk+ β16Dl+ β17Dm+ β18DIF+ β19DVVS1+ β20DVVS2+ β21DVS1+ β22DVS2+ β23DSI1+ β24DSI2+ β25DI1+ β26DI2
Now I will make interaction dummy variable and add them up too.
Diamond prices = β0+ β1SZ+ β2DR+ β3DO+ β4DE+ β5DP+ β6DPR+ β7DT+ β8DH+ β9Dd+ β10De+ β11Df+ β12Dg+ β13Dh+ β14Dj+ β15Dk+ β16Dl+ β17Dm+ β18DIF+ β19DVVS1+ β20DVVS2+ β21DVS1+ β22DVS2+ β23DSI1+ β24DSI2+ β25DI1+ β26DI2+ β27(DR*C)+ β28(DO*C)+ β29(DE*C)+ β30(DP*C)+ β31(DPR*C)+ β32(DT*C)+ β33(DH*C)+ β34(Dd*C)+ β35(De*C)+ β36(Df*C)+ β37(Dg*C)+ β38(Dh*C)+ β39(Dj*C)+ β40(Dk*C)+ β41(Dl*C)+ β42(Dm*C)+ β43(DIF*C)+ β44(DVVS1*C)+ β45(DVVS2*C)+ β46(DVS1*C)+ β47(DVS2*C)+ β48(DSI1*C)+ β49(DSI2*C)+ β50(DI1*C)+ β51(DI2*C)

Now I will run regression test and find out the general model. Variable | Coefficient | Std. Error | t-Statistic | Prob. | C | 314876.7 | 475015.9 | 0.662876 |

You May Also Find These Documents Helpful

  • Good Essays

    Study Guide

    • 1347 Words
    • 6 Pages

    COMPANY BACKGROUND: EasyFind manufactures and sells golf balls. The company is conducting a price test to find a better price point. Presently their golf balls sell for $19 per dozen. Their current volume is 5,470 dozen per month. They are considering reducing their sales price by 20% per dozen.…

    • 1347 Words
    • 6 Pages
    Good Essays
  • Good Essays

    The types of pennies are a qualitative variable. Qualitative data consist of values that can be placed into non-numerical categories.…

    • 332 Words
    • 2 Pages
    Good Essays
  • Good Essays

    24 Karat Club Case Study

    • 833 Words
    • 4 Pages

    Fast Forward to 2005. A bright-eyed genius entered the AGS world. He had some tall marching orders, as well when he joined the Research and Development team, led by Pete. We once again had a vision: revolutionize the diamond industry with the most advanced cut grade system yet, which, in turn, would give consumers even more thorough and consistent diamond grading reports.…

    • 833 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Economics Quiz Paper

    • 2062 Words
    • 9 Pages

    15. In a competitive market, the market demand is Qd = 60 - 6P and the market supply is Qs = 4P. A price ceiling of $3 will result in…

    • 2062 Words
    • 9 Pages
    Satisfactory Essays
  • Good Essays

    Oligopoly and Match Price

    • 477 Words
    • 2 Pages

    Price (per unit) |$0.30 |$0.40 |$0.50 |$0.60 |$0.70 |$0.80 |$0.90 | |Quantity demanded per period (in millions) |10 |9 |8 |7 |6 |5 |4 | |…

    • 477 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    MATH Asgn3

    • 943 Words
    • 8 Pages

    The price of a diamond is based on the diamond's weight, color, and clarity. A simple random…

    • 943 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Atlantic Computer

    • 346 Words
    • 2 Pages

    To calculate the prices you could use the spreadsheet file included in the course content (Week 3).…

    • 346 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Science

    • 1186 Words
    • 5 Pages

    _To tell if it’s real diamond check out it’s density, find it’s mass and volume, see if it’s luster…

    • 1186 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Managerial Economics

    • 9650 Words
    • 39 Pages

    In a competitive market, the market demand is Qd = 60 - 6P and the market supply is Qs = 4P. The full economic price under a price ceiling of $3 is A. B. C. D. 6. 7. 8. 9.…

    • 9650 Words
    • 39 Pages
    Satisfactory Essays
  • Powerful Essays

    Blood Diamonds

    • 3425 Words
    • 14 Pages

    The name "diamond" comes from the Greek word, "adamas" meaning unconquerable. Fittingly diamonds are made of pure carbon, and diamonds are the hardest natural substance known to man.[1][1] Diamonds have long been a sign of wealth and fortune. Kings and queens have worn these forms of concentrated carbon and even more countless millions people over time have lusted after them. These gems can be transparent, truculent white, yellow, green, blue, or brown. To understand the value of these stones, and ultimately their role in war, it helps to first understand their origins and where they come form.…

    • 3425 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    Suppose that the tin mining market is perfectly competitive. The market demand curve is given by D(P) = 300 – P, where D is measured in units per year, and P is measured in $ per units.…

    • 1532 Words
    • 6 Pages
    Satisfactory Essays
  • Better Essays

    |Price |Marketing Budget |Promotion |Purchase | |Standard Ice Cream |280 |4000 |Commercial – Rich history |500 | |Special Ice Cream |295 |4000 |Commercial –…

    • 2678 Words
    • 11 Pages
    Better Essays
  • Good Essays

    The Diamond and Fine Jewelry industry has significantly changed since launching the Blue Nile’s webstore. Blue Nile offers certified diamonds and fine jewelry at prices substantially below traditional retail with the highest quality and their true success is in result of well-organized EC, which offers education, guidance and expertize opinion on all products (via phone, email or life chat). Their online catalog with a variety of 70,000 round diamonds with customized options beats any physical store’s inventory and at the same time grooms save between $3,000 and $5,000 when proposing.…

    • 373 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Student

    • 3639 Words
    • 15 Pages

    Before figuring it out, we need to refer to prices. Considered the price of gold and slivers,…

    • 3639 Words
    • 15 Pages
    Good Essays
  • Satisfactory Essays

    Scholar

    • 302 Words
    • 2 Pages

    • The “Black Diamonds” are worth about R180 Billion and make up 28% of the south African spending power.…

    • 302 Words
    • 2 Pages
    Satisfactory Essays