Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Mathematics questions