Question

In: Statistics and Probability

Provide Mean, Median, Mode, Upper and Lower Limit Any null or missing values Detect any outliers...

Provide Mean, Median, Mode, Upper and Lower Limit

  • Any null or missing values
  • Detect any outliers or data points of interest
    • Provide a paragraph for each column with facts from the previous 3 bullets and provide the business context behind the importance of the column, showing the analysis and how this helps you in the preparation stages.

    • Month

      Year

      N Obs

      Variable

      Mean

      Std Dev

      Minimum

      Maximum

      Median

      N

      N Miss

      1

      2016

      3584

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      4.0231585
      4.7360491
      5.5172991
      0.7460938
      0.5957031

      2.0277917
      2.4579240
      2.9140122
      0.4353053
      0.4908239

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      6.0000000
      1.0000000
      1.0000000

      3584
      3584
      3584
      3584
      3584

      0
      0
      0
      0
      0

      2017

      3584

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      4.0474330
      4.7126116
      5.5167411
      0.7460938
      0.5904018

      1.9896422
      2.4584740
      2.8495141
      0.4353053
      0.4918282

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3584
      3584
      3584
      3584
      3584

      0
      0
      0
      0
      0

      2

      2016

      3604

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      3.9919534
      4.7130966
      5.4642064
      0.7522198
      0.5810211

      1.9889206
      2.4250830
      2.8749679
      0.4317834
      0.4934604

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3604
      3604
      3604
      3604
      3604

      0
      0
      0
      0
      0

      2017

      3522

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      3.9400909
      4.7118115
      5.5008518
      0.7413401
      0.5800681

      1.9807623
      2.4473141
      2.8953389
      0.4379605
      0.4936175

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3522
      3522
      3522
      3522
      3522

      0
      0
      0
      0
      0

      3

      2016

      3625

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      3.9798621
      4.6780690
      5.4419310
      0.7514483
      0.5961379

      1.9948561
      2.4453918
      2.8590908
      0.4322329
      0.4907382

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3625
      3625
      3625
      3625
      3625

      0
      0
      0
      0
      0

      2017

      3498

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      4.0437393
      4.6329331
      5.4765580
      0.7481418
      0.6177816

      1.9829346
      2.4520967
      2.8817401
      0.4341423
      0.4859990

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3498
      3498
      3498
      3498
      3498

      0
      0
      0
      0
      0

      4

      2016

      3488

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      3.9650229
      4.6662844
      5.4440940
      0.7428326
      0.6002294

      2.0276079
      2.4055163
      2.9074777
      0.4371351
      0.4899213

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3488
      3488
      3488
      3488
      3487

      0
      0
      0
      0
      1

      2017

      3584

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      3.9455915
      4.6582031
      5.4972098
      0.7580915
      0.6035156

      1.9872880
      2.4224678
      2.8647030
      0.4282989
      0.4892354

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3584
      3584
      3584
      3584
      3584

      0
      0
      0
      0
      0

      5

      2016

      3533

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      4.0118879
      4.6787433
      5.4189074
      0.7472403
      0.5767271

      1.9951456
      2.4580497
      2.8687807
      0.4346558
      0.4941478

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      5.0000000
      1.0000000
      1.0000000

      3533
      3533
      3533
      3533
      3532

      0
      0
      0
      0
      1

      2017

      3532

      Day_of_Week
      Items_In_Cart
      Visit_To_Site
      Made_Purchase
      Member

      3.9949037
      4.6868630
      5.4963194
      0.7364100
      0.5821065

      2.0033891
      2.4034851
      2.9178768
      0.4406419
      0.4932823

      1.0000000
      1.0000000
      1.0000000
      0
      0

      7.0000000
      9.0000000
      10.0000000
      1.0000000
      1.0000000

      4.0000000
      5.0000000
      6.0000000
      1.0000000
      1.0000000

      3532
      3532
      3532
      3532
      3532

      0
      0
      0
      0
      0

Solutions

Expert Solution

Mode Lower limit Upper limit
3.953683 0.048686768 7.997630232
5.527902 -0.08148194 9.55358014
6.965402 -0.19416481 11.22876301
1.507812 -0.10710459 1.599292188
1.808594 -0.36631174 1.557717944
3.905134 0.147734288 7.947131712
5.574777 -0.10599744 9.53122064
3.966518 -0.06830654 11.10178874
1.507812 -0.10710459 1.599292188
1.819196 -0.37358147 1.554385072
4.016093 0.093669024 7.890237776
5.573807 -0.04006608 9.46625928
4.071587 -0.17073068 11.09914348
1.49556 -0.09407566 1.598515264
1.837958 -0.38616128 1.548203484
4.119818 0.057796792 7.822385008
5.576377 -0.08492414 9.508547136
3.998296 -0.17401244 11.17571604
1.51732 -0.11706248 1.59974268
1.839864 -0.3874222 1.5475584
4.040276 0.069944144 7.889780056
5.643862 -0.11489893 9.471036928
4.116138 -0.16188697 11.04574897
1.497103 -0.09572818 1.598624784
1.807724 -0.36570897 1.557984772
3.912521 0.157187484 7.930291116
5.734134 -0.17317643 9.439042632
4.046884 -0.1716526 11.1247686
1.503716 -0.10277711 1.599060708
1.764437 -0.33477644 1.57033964
4.069954 -0.00908858 7.939134384
5.667431 -0.04852755 9.381096348
4.111812 -0.25456229 11.14275029
1.514335 -0.1139522 1.599617396
1.799541 -0.36001635 1.560475148
4.108817 0.05050702 7.84067598
5.683594 -0.08983379 9.406239988
4.00558 -0.11760808 11.11202768
1.483817 -0.08137434 1.597557344
1.792969 -0.35538578 1.562416984
3.976224 0.101402524 7.922373276
5.642513 -0.13903411 9.496520712
4.162185 -0.20390277 11.04171757
1.505519 -0.10468507 1.599165668
1.846546 -0.39180259 1.545256788
4.010193 0.068261064 7.921546336
5.626274 -0.0239678 9.397693796
7.007361 -0.22271913 11.21535793
1.52718 -0.12724812 1.600068124
1.835787 -0.38472681 1.548939808

Outliers:

From this plot we see that the points below one are all outliers, they affect on the data.

This is the information about the variable Day_of_Week Items_In_Cart Visit_To_Site Made_Purchase Member having comparison of two years 2016 and 2017 of six months.

orchestra answered 2 years ago
Next > < Previous

Related Solutions

1. For the table below, fill in the missing sections for the Mean, Median, Mode, Range,...
1. For the table below, fill in the missing sections for the Mean, Median, Mode, Range, and Standard Deviation on your own. Remember to round to two decimal places. Hint: Put it in SPSS to simplify the calculation of the standard deviation, using the “Means” test under the Analyze menu! Then complete the five questions and transfer your answers to the quiz in Canvas Condition 1 Scores Condition 2 Scores 4, 1, 2, 4, 2, 3, 7, 4, 3, 5,...
Mean , Median and Mode
The mean of 8,11,6,14,m and 13 is 11 a) Find the value of m. b) Find the median and mode of given data set.
Why Mean, Median and Mode are called centrality measurements? Provide an example in which the Median...
Why Mean, Median and Mode are called centrality measurements? Provide an example in which the Median is a better indicator than the Mean Why Range, Mean Average Deviation, Variance and Standard Deviation are called Dispersion Measurements
Explain the relative positions of the mean, mode, and median as affected by any skewing in...
Explain the relative positions of the mean, mode, and median as affected by any skewing in a scatter chart.
1. There is a lower limit but no upper limit for a random variable that follows...
1. There is a lower limit but no upper limit for a random variable that follows the a. ​uniform probability distribution. b. ​exponential probability distribution. c. ​normal probability distribution. d. ​binomial probability distribution. 2. The weight of football players is normally distributed with a mean of 200 pounds and a standard deviation of 25 pounds. What is the minimum weight of the middle 95% of the players? a. 196 b. 190 c. 151 d. 249 3. A scatter diagram reveals...
9. (6 pts) What are outliers? Describe the effects of outliers on the mean, median, and...
9. (6 pts) What are outliers? Describe the effects of outliers on the mean, median, and mode.
What is the difference between a mean, median and mode of a dataset? Provide an example...
What is the difference between a mean, median and mode of a dataset? Provide an example of when it would be appropriate to report each of these. What is a standard deviation? Why is it necessary to report both a measure of center and a measure of spread?
Upper Control Limit (UCLx). (3 marks) Lower Control Limit (LCLx). (3 marks) Upper Control Limit (UCLR).
Upper Control Limit (UCLx). Lower Control Limit (LCLx). Upper Control Limit (UCLR).
Find the mean, median, and mode of the following set of data. (Enter solutions for mode...
Find the mean, median, and mode of the following set of data. (Enter solutions for mode from smallest to largest. If there are any unused answer boxes, enter NONE in the last boxes.) (a) 6 6 7 8 9 12 Mean Median Mode Mode (b) 6 6 7 8 9 108 Mean Median Mode Mode
Lower limit = Q1 – 1.5Å~IQR Upper limit = Q3 + 1.5Å~IQR IQR = Q3 −...
Lower limit = Q1 – 1.5Å~IQR Upper limit = Q3 + 1.5Å~IQR IQR = Q3 − Q1 1. The manager of a local fast-food chain wants to improve the service provided to customers who use the drive-up window. As a first step in this process, the manager records how long it takes from the time the customer first enters the drive-in window until they are served their food at the final window. Below are the times (in minutes) for the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT