Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Aakarsh Gupya DS Assignment

    Uploaded by

    Aka G
    The document appears to contain sales data for 15 sales representatives. It includes the number of sales calls made (Column 2) and copiers sold (Column 3) by each rep. There is a positive linear relationship between the number of sales calls and copiers sold, as evidenced by a regression analysis summary in Columns 5-9 with a multiple R of 0.8678 and R square of 0.7531.

    Copyright:

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

    Aakarsh Gupya DS Assignment

    Uploaded by

    Aka G
    28 views7 pages
    The document appears to contain sales data for 15 sales representatives. It includes the number of sales calls made (Column 2) and copiers sold (Column 3) by each rep. There is a positive linear relationship between the number of sales calls and copiers sold, as evidenced by a regression analysis summary in Columns 5-9 with a multiple R of 0.8678 and R square of 0.7531.

    Original Title

    Aakarsh gupya DS Assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document appears to contain sales data for 15 sales representatives. It includes the number of sales calls made (Column 2) and copiers sold (Column 3) by each rep. There is a positive linear relationship between the number of sales calls and copiers sold, as evidenced by a regression analysis summary in Columns 5-9 with a multiple R of 0.8678 and R square of 0.7531.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    28 views7 pages

    Aakarsh Gupya DS Assignment

    Uploaded by

    Aka G
    The document appears to contain sales data for 15 sales representatives. It includes the number of sales calls made (Column 2) and copiers sold (Column 3) by each rep. There is a positive linear relationship between the number of sales calls and copiers sold, as evidenced by a regression analysis summary in Columns 5-9 with a multiple R of 0.8678 and R square of 0.7531.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 7

    Column1 Column2 Column3 Column4

    Copiers
    Sales Rep Sales Calls (x)
    Sold(y)
    Brian Virost 96 41
    Carlos Ramirez 40 41
    Carol Saia 104 51
    Greg Fish 128 60
    Jeff Hall 164 61
    Mark Reynolds 76 29
    Meryl Rumsey 72 39
    Mike Kiel 80 50
    Ray Snarsky 36 28
    Rich Niles 84 43
    Ron Broderick 180 70
    Sal Spina 132 56
    Soni Jones 120 45
    Susan Welch 44 31
    Tom Keller 84 30

    Mean x=96 Mean Y = 45

    80

    70

    60

    50
    Copiers sold

    40

    30

    20

    10

    0
    0 20
    0 20
    Column5 Column6 Column7 Column8 Column9
    ⬚ 2 ⬚ 2
    (x - ^x) (y -^Y) (x-^x)(y-^Y) (𝑥−^𝑥 ) (𝑦−^𝑌 )
    0 -4 0 0 16 Regression Stati
    -56 -4 224 3136 16
    8 6 48 64 36
    32 15 480 1024 225
    68 16 1088 4624 256
    -20 -16 320 400 256
    -24 -6 144 576 36
    -16 5 -80 256 25
    -60 -17 1020 3600 289
    -12 -2 24 144 4
    84 25 2100 7056 625
    36 11 396 1296 121
    24 0 0 576 0
    -52 -14 728 2704 196
    -12 -15 180 144 225

    6672 25600 2326

    Scatter plot

    20 40 60 80 100 120 140 160 180 200


    sales calls
    20 40 60 80 100 120 140 160 180 200
    sales calls
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.867835724
    R Square 0.753138844
    Adjusted R Square 0.732567081
    Standard Error 6.891825731
    Observations 14

    ANOVA
    df SS Significance F
    Regression 1 1738.89 5.75293E-05
    Residual 12 569.9671429
    Total 13 2308.857143

    Coefficients Standard Error t Stat P-value Lower 95%


    Intercept 20.26571429 4.526773227 4.476857 0.000757 10.4027227
    96 0.260625 0.043073911 6.050646 5.75E-05 0.16677501

    200
    200
    Sales Calls (x) Copiers Sold(y)

    Mean 96 Mean 45
    Standard Error 11.04104895 Standard Error
    3.328091

    Median 84 Median 43
    Mode 84 Mode 41
    Standard Deviation 42.76179871 Standard Deviation
    12.88964
    Sample Variance 1828.571429 Sample Variance
    166.1429
    Kurtosis -0.320451923 Kurtosis -0.73063
    Skewness 0.463030102 Skewness 0.357454
    Range 144 Range 42
    Minimum 36 Minimum 28
    Maximum 180 Maximum 70
    Sum 1440 Sum 675
    Count 15 Count 15

    Upper 95% Lower 95.0% Upper 95.0%


    30.12870587 10.4027227 30.12870587
    0.35447499 0.16677501 0.35447499

    You might also like