Data Analytics Capstone Power Point Slides Needing Additional Topic And Solution To Be Completed!

User Generated

ifbavv

Computer Science

Columbus State Community College

Description

This link https://audr-apps.franklincountyohio.gov/reporter can be use for the one topic/idea to be added with solution and discussions. Be sure to select City filter - pull Westerville with all desired filters/parameters, then pull Gahanna in the same way. Files Name Used Westerville.csv,Gahanna.csv, and Rental.csv. Additional Information Useful If needed link below.https://docs.google.com/document/d/1I5XGSw0n05q6SHHVkw_HNLmmS2hRqgo16BDHN2BKUmk/edit?usp=sharing

Presentation Slides Already Done is https://docs.google.com/presentation/d/1-Xsb7Ad6Ok...

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Current Market Value &
Net Annual Tax Comparisons
for Houses in
Westerville & Gahanna, Ohio
Group 3 Lab 2

Statistical Research Question
Are current housing market values greater in the City of Westerville than the City
of Gahanna? Are housing market values and net annual tax amounts correlated?

Hypothesis
Research Question: Are current housing market values greater in the City of Westerville
than the City of Gahanna?
● Null hypothesis (H0): The mean current housing market values in Westerville are
equal to the mean market values in Gahanna (Ho: μ1 = μ2).
● Alternative hypothesis (Ha): The mean current housing market values in Westerville
are not equal to the mean market values in Gahanna (Ha: μ1 ≠ μ2).
Research Question: Are housing market values and net annual tax amounts correlated?
● Null hypothesis (H0): There is no statistically significant correlation between
housing market values and net annual tax amoun...

Related Tags