Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(8 marks total) Data screening is an important procedure prior to starting any analysis to ensure there are no mistakes in the data entry or
(8 marks total) Data screening is an important procedure prior to starting any analysis to ensure there are no mistakes in the data entry or unusual values that you need to be aware of. For categorial and ordinal variables we use frequency tables (Pivot tables) to determine if all values are accounted for. For quantitative variables we use summary statistics (mean, minimum, maximum, and standard deviation) to check for any discrepancies. Use Excel to screen the dataset Australian Vehicle Prices 2023.xlsx. In your answer provide only the relevant Excel output for the variables Seats and FuelType (2 marks). Describe any potential problems or mistakes you can identify for these variables from this screening process (4 marks). For Seats, how would you resolve the issue (explain how only - no need to edit the data set)
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
Get Started