KSU Databases Relationship Significance Testing Lab Project

Having Trouble Meeting Your Deadline?

Get your assignment on KSU Databases Relationship Significance Testing Lab Project completed on time. avoid delay and – ORDER NOW

Do My Paper

Data Transformation Assignment

Task 1: Quantitative Transformation (Refer to the Data Transformation Lecture Manual and Videos for Help)

Instructions: Perform all analysis in a newly created worksheet “Quant Transform Data”

1. READ THE BACKGROUND INFO FIRST
2. The variables Living Area, Masonry Veneer Area, and Sale Price all have either slightly or significantly skewed distributions. Refer to your data diagnosis and univariate analysis to confirm the skew. Perform 2 transformations for each of the 3 variables. Remember root transformations for right skewed data and power transformations for left skewed data. Paste your excel formulas in the assignment submission form.
3. Create a simple histogram for each newly transformed variable and the original. You do not need to format these perfectly, just make sure there is enough information to tell which transformation it is. Paste your simple histograms in the assignment submission form.
4. Calculate the mean and median of each variable transformation and format it in a table with borders and shading, rounding, etc. You can just use the =median() and =average() functions for a quick and easy method. Paste your table in the assignment submission form.
5. Create a single correlation matrix with all the quantitative variables expect ID (ID… it’s not a quantitative variable to begin with, just an identifier) and format it neatly (round your decimals, add a title, and some borders, etc..). Paste your table in the assignment submission form.
6. Provide a brief write up of the changes in distribution shape. Are they becoming more symmetric? Are the means and medians getting closer together?
7. Provide a brief write up of the changes in the correlation values. As we move through the transformations, are the relationships getting stronger or weaker with each transformation?

Task 2: Categorical Transformation (Preparation (Refer to the Data Transformation Lecture Manual and Videos for Help)

Instructions: Perform all analysis in a newly created worksheet “Cat Transform Data”

1. READ THE BACKGROUND INFO FIRST
2. REDUCE: Combine all underrepresented categories for House Style, Overall Quality, and Kitchen Quality with the most logical category for the variable. Paste your if statements in the assignment submission form.
3. House Style (2.5 Story is underrepresented)
4. Kitchen Quality (Poor is underrepresented)
5. Overall Quality (Very Poor, Poor, Fair, and Very Excellent are underrepresented)
6. CHECK: Create simple pivot tables for your newly reduced variable to check that the combinations were successful. These do not need to be professional formatted. This is just a sanity check. Paste your simple pivot tables in the assignment submission form.
7. NUMERICALLY ENCODE: Recode the newly reduced categorical variables and the foundation variable as numbers. Remember the nominal variables are always dummy coded and ordinal variables can be rank coded if they show an increasing or decreasing relationship with the target. Paste your if statements in the assignment submission form.
8. House Style
9. Foundation
10. Kitchen Quality
11. Overall Quality