Scribd Logo
Upload

Welcome to Scribd!

  • 34 views

    Source Economist Pocket World in Figures 2011 Country Pop (Millions) Sales/Capita Computer Sales GNP Per Head Unemployment Rate

    Uploaded by

    Bhargav Sri Dhavala
    This document contains a summary of computer and GNP data from 21 countries. It includes each country's population, computer sales, computer sales per capita, GNP per head, and unemployment rate. Additional data is presented on percentage spent on education and GNP per head in thousands for each country. This data is then preprocessed and regression analysis is performed to forecast values with independent variables of population, unemployment rate, percentage spent on education, and GNP per head in thousands.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Source Economist Pocket World in Figures 2011 Country Pop (Millions) Sales/Capita Computer Sales GNP Per Head Unemployment Rate

    Uploaded by

    Bhargav Sri Dhavala
    34 views5 pages
    This document contains a summary of computer and GNP data from 21 countries. It includes each country's population, computer sales, computer sales per capita, GNP per head, and unemployment rate. Additional data is presented on percentage spent on education and GNP per head in thousands for each country. This data is then preprocessed and regression analysis is performed to forecast values with independent variables of population, unemployment rate, percentage spent on education, and GNP per head in thousands.

    Original Title

    CGT21002 Grocery

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a summary of computer and GNP data from 21 countries. It includes each country's population, computer sales, computer sales per capita, GNP per head, and unemployment rate. Additional data is presented on percentage spent on education and GNP per head in thousands for each country. This data is then preprocessed and regression analysis is performed to forecast values with independent variables of population, unemployment rate, percentage spent on education, and GNP per head in thousands.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    34 views5 pages

    Source Economist Pocket World in Figures 2011 Country Pop (Millions) Sales/Capita Computer Sales GNP Per Head Unemployment Rate

    Uploaded by

    Bhargav Sri Dhavala
    This document contains a summary of computer and GNP data from 21 countries. It includes each country's population, computer sales, computer sales per capita, GNP per head, and unemployment rate. Additional data is presented on percentage spent on education and GNP per head in thousands for each country. This data is then preprocessed and regression analysis is performed to forecast values with independent variables of population, unemployment rate, percentage spent on education, and GNP per head in thousands.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 5

    Name Amit Prakash Singh Roll No CGT21002

    Source Economist Pocket World in Figures 2011


    Computer GNP per Unemployment
    Country Pop (millions) Sales Sales/Capita head rate
    1 Austria 8.4 941.2 $112.05 $49,600 4.2
    2 Belgium 10.5 1681.9 $160.18 $47,090 8.1
    3 Bulgaria 7.6 154 $20.26 $6,550 13.5
    4 Czech Rep. 10.2 1028.7 $100.85 $20,670 6.6
    5 Denmark 5.5 935.4 $170.07 $62,120 5.2
    6 Finland 5.3 1971 $371.89 $51,320 9.9
    7 France 61.9 5928.9 $95.78 $44,510 10
    8 Germany 82.5 6824.3 $82.72 $44,450 9.1
    9 Greece 11.2 813 $72.59 $31,670 9.9
    10 Hungary 10 449 $44.90 $15,410 7.3
    11 Ireland 4.4 576.9 $131.11 $60,460 6.3
    12 Italy 58.9 3858.2 $65.50 $38,490 9.3
    13 Netherlands 16.5 2168.5 $131.42 $52,960 4.4
    14 Poland 38 2847 $74.92 $13,850 14.4
    15 Portugal 10.7 728.6 $68.09 $22,920 6.3
    16 Romania 21.3 687.2 $32.26 $9,300 7
    17 Spain 44.8 4745.8 $105.93 $35,220 14.2
    18 Switzerland 7.5 1130.4 $150.72 $64,430 3.6
    19 Sweden 9.2 2113.4 $229.72 $51,950 6.3
    20 Turkey 75.8 2879 $37.98 $9,940 8.6
    21 UK 61 9887.2 $162.09 $43,540 5.9
    CGT21002

    Figures 2011 Data Preprocessed


    %age spend on GNP per Head (in
    education Thousands) Forecast Error^2 Sum-Error R-Square
    5.8 49.6 1363.9552 178722 31827344.4953 0.7453496
    5.9 47.09 1644.9298 1366.7974
    3.5 6.55 -165.8918 102330.79
    4.4 20.67 327.97869 491010.35
    8.4 62.12 1873.6273 880270.53
    6.3 51.32 1522.4538 201193.69
    5.7 44.51 5810.4376 14033.336
    4.6 44.45 7368.1002 295718.71
    3.9 31.67 1021.548 43492.26
    5.1 15.41 170.35936 77640.606
    4.3 60.46 1517.5877 884893.35
    5 38.49 5230.0653 1882014
    5 52.96 2126.5839 1756.9587
    5.6 13.85 2797.497 2450.544
    5.9 22.92 541.22732 35108.521
    3.3 9.3 703.45252 264.14437
    4.4 35.22 4170.1419 331382.24
    5.6 64.43 1873.6278 552387.58
    7.6 51.95 1753.79 129319.38
    3.7 9.94 5278.878 5759414
    4.8 43.54 5419.2504 19962574
    Indendent Variables
    Constant -2006.934
    Pop (millions) 81.417543
    Unemployment rate 53.848607
    %age spend on education 62.304868
    GNP per Head (in Thousands) 42.327616

    Assuming there are no seasonaity in the dataset.


    Grocery

    Chapter 8 Name Amit Prakash Singh Roll No CGT21002


    Problem 1

    Price
    Cart Reduction Cart Price Price
    Week Notice? Coupon? ? Sales Notice Coupon Redn 0 Redn 1 Forecast*
    1 Yes Yes 0 36 1 1 1 0 34
    2 Yes Yes 1 38 1 1 0 1 39
    3 Yes Yes 2 40 1 1 0 0 46
    4 Yes No 0 40 1 0 1 0 35
    5 Yes No 1 42 1 0 0 1 40
    6 Yes No 2 44 1 0 0 0 47
    7 No Yes 0 12 0 1 1 0 13
    8 No Yes 1 20 0 1 0 1 18
    9 No Yes 2 30 0 1 0 0 26
    10 No No 0 8 0 0 1 0 14
    11 No No 1 16 0 0 0 1 19
    12 No No 2 33 0 0 0 0 27

    Page 4
    Grocery

    Independent
    Error^2 Sum Error R-Squre Variable
    6.249836 198.5833 0.89 Constant 27.24997 27.24995
    0.250011 Cart Notice 20.16668 20.16667
    39.06258 Coupon -1.166644 -1.166676
    28.44433 Price Reduction 0 -12.74997 -12.74995
    5.444498 1 -7.749995 -7.749946
    11.6735
    1.777826
    2.777791
    15.34035
    42.24994
    12.24982
    33.06285

    Page 5

    You might also like