# Univariate/Multivariate Analysis, Brief Assignment, 5 Parts

CSCI N207 Assignment Four

Univariate/Multivariate Analysis

Description

Use the attached SalariesIndianaNewYork.xls file and compare the total employment and salary for various jobs in the state of Indiana and New York. You can compare in any way you like as long as the following requirements are met. Your analysis and conclusion must make sense, e.g. it does not make sense to draw a conclusion that the average hourly salary in Indiana is smaller than the average yearly salary in New York.

Requirements and Rubrics

1. Perform at least 3 descriptive statistics. You can use Excel functions. Explain the purpose of your analysis and your conclusion. For instance, you can compare the average yearly salary of Indiana and average yearly salary of New York, and see which state is higher, or you can compare average hourly salary in computer/math fields (job codes start with 15-) with the average hourly salary in management fields (job codes starts with 11-)  (25â)

2. Create one or two frequency tables. Determine a reasonable bin size. You can use the COUNTIFS() function to have Excel do the counting according to a criteria. E.g. =COUNTIFS(B2:B87, ">8.07", B2:B87, "<=21.45") will count within B2 and B87 range, how many data are >8.07 and <=21.45. Explain your findings from the frequency table. (20â)

3. Perform at least 1 multivariate analysis. Explain the purpose of your analysis and your conclusion. (20â)

4. Give a summary of your comparison between the two states, any additional findings you have or any additional analysis you would like to perform. (20â)

5. Create a separate sheet to perform your analysis and present your result. Label each step (1 â 4 above). (10â)

6. Your project file name should be in the format of lastname_assiagnment4.xlsx. (5â)

## Related Questions

Similar orders to Univariate/Multivariate Analysis, Brief Assignment, 5 Parts
16
Views
0
Data Visualisation
I have uploaded the coursework brief below. It's asking us to create an "interactive poster". It's mostly explained in the coursework brief. I am aiming to get at least 70% on it (first class) and I would like you to give me a quote on how much it would co...
11
Views
0
Wonderlic 2021
Must get 20/30 correct !...
99
Views
0
small sample size issues in data analysis
Hello, I'm working on a project with a dataset that has around 5000 observations every year (different participants each year). These observations are distributed over the 50 states but not equally distributed, so I need help with the following please: ...
166
Views
1