) Perform an exploratory data analysis (EDA) on the Quber ride ratings and discuss the following features for each Quber ride service: The shape of
)Perform an exploratory data analysis (EDA) on the Quber ride ratings and discuss the following features for each Quber ride service:
The shape of the distribution (symmetric, skewed left, skewed right) and whether there are outliers present. Support your discussion by using the boxplot and descriptive statistics to refer to the location of the median, and to describe the whisker lengths and presence/lack of outliers.
E ('3 ' Assignment} Data External 2022.xlsx , Excel File Horne insert Page Layout Formulas Review View Help 9 Tell me what you want to do F DD From Text/CSV I}; Recent Sources '1'} El Queries 8: Connections Y :E El 3"" n '5 "I Group v 7-) Solver an E :1 Q 7. 7 El @ From Web D Existing Connections "U 5% ' Ungroup v 7D Data Analysis Get Refresh 2i Sort Filter Text to D, Whatilf Forecast r: Data v l:l me Table/Range All V A Y/'AdVanCEd Columns :9 V ll Analysis V Sheet 55: Subtotal Get at Transform Data Queries 81 Connections Sort & Filter Data Tools Forecast Outline 5 Analysis /\\ K23 ' f: Standard Error V A B c D , E , F G H I , J K L M ' A 1 27 1 4 3, 5 4 Ride Data 47 5 4 5, 5 4 Remember to add your initials to each column name! 67 3 3 7, 4 4 The data in this file contains the customer ratings per journey related to the Quber service selected. 67 4 5 9_ 5 4 The ratings scale went from 1 (Disaster - can I get a refund) through to 5 (Can this driver take me every time) 107 5 4 11_ 3 4 Remember the benchmarks that Quher put in place 127 3 4 137 3 4 QuberPaal: Rating benchmark of 4 stars 147 4 5 15, 2 3 QuberX: Rating benchmark of 5 stars 167 4 3 177 3 5 x: 18_ 3 4 197 3 5 l Appendix 1 Appendix 1e Appendix 2 l (-9 4 r Ready (bAccessibilityood to go E J 7 I'l + 90% Assignment 3 Data External 2022.xlsx - Excel Sonal ghost SG X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do C fx 2 A Q ... Define Name ~ " Trace Precedents 15% Show Formulas fx Use in Formula ~ out Trace Dependents Error Checking Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Watch Calculation Function Used Time " Reference " Trig " Functions Manager DT Create from Selection ix Remove Arrows ~ fx Evaluate Formula Window Options Function Library Defined Names Formula Auditing Calculation D17 X fx C D E F G H J K L M N O 19 20 QuberPool QuberX QuberPool Quberx 21 22 Quartile 1 4 Mean 3.7468 Mean 4.058 23 Quartile 3 5 Standard Error 0.015570049 Standard Error 0.01640128 24 IQR Median Median 25 Mode 4 Mode 4 26 Standard Deviation 1. 100968749 Standard Deviation 0.820064023 27 Sample Variance 1.212132186 Sample Variance 0.672505002 28 Kurtosis -0.28949393 Kurtosis -0.305625405 29 Skewness -0.690412141 Skewness -0.547466813 w 30 Range 4 Range 31 Minimum Minimum 2 32 Maximum 5 Maximum 33 Sum 18734 Sum 10145 34 Count 5000 Count 2500 35 36 37 Appendix 1 Appendix 1e Appendix 2 + + 90% Ready Accessibility: Good to go
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance