Assignment 1 updated

.docx

School

Texas A&M University, Commerce *

*We aren’t endorsed by this school

Course

511

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

3

Uploaded by GeneralExploration15673

Report
1. Identify a question that you can solve using the provided dataset. (10) How many recall that Honda (American Honda Motor Co.) had in 2023? 2. Identify the types of variables in the dataset. (10) Report Received Date Continuous NHTSA ID Continuous Recall Link Nominal Manufacturer Nominal Subject Nominal Component Nominal Mfr Campaign Number Continuous Recall Type Nominal PotentiallyAffected Discrete Park Outside Advisory Nominal Do Not Drive Advisory Nominal Completion Rate %(Blank - Not Reported) Continuous 3. Evaluate the quality of the provided dataset. (10) Accuracy: yes it’s accurate since it’s from government officials website database Completeness: not complete due to some blank left in data for example some date not reported in completion rate. Consistency: Yes the date base from 1966 to 2024 still updating Usability: yes the date set can be use different to answer various questions base on what date we want to search related to recalls 4. Develop 3 different visualizations using different variables in Excel. (30) See excel visual 5. What are insights from the descriptive statistics of “Potentially affected”? (20)
Mean is greater than median, the large difference mean it has outliers, the mode is close to center, The skewness is a high positive distribution, and kurtosis 500+ is high number presence of outlier in data. 6. Compare the descriptive statistics of “Potentially affected” for “FIAT MOTORS OF N.A., INC.” and “Mazda Motor Corp.” (20) On Mean, median FIAT has less potentially affected compared to Mazda, Fiat standard deviation is less then Mazda so Flat is more narror when Mazda date is more spread out. I can make assumption Mazda
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help