What are the large correlations? What does this tell you about the respondents social media behavior?

Please complete the work that is in the excel sheet in the excel sheet. Use the data on the Class Survey page for your analysis. Choose the appropriate question tab for the Excel-generated report. Do not replicate the data on any of the question tabs. Provide the required answers to the questions (based on the analysis you performed on the other tabs) in the textbox below.

In a recent semester, Dr. Nittrouer surveyed sections of MGT 4317 about technology usage. (See MGT 4317 Survey.docx for the complete survey.) Data from the survey can be found in Class Survey.xlsx. Using this data and the technology survey, perform the tasks below. Carefully follow the directions on the spreadsheet for how to format your answers. I give the most credit to students who follow directions! When you finish, please post the completed spreadsheet in the assignment drop box. If you have any questions, please dont hesitate to ask.
1. Compute descriptive statistics for the following variables: Usage1, Usage2, Usage3, Usage4, Usage5, Usage6, Usage7, Usage8, Usage9, Usage10, and Q44_11. Note: these variables are from Question 44 of the MGT 4317 Survey document and are defined in the Variable Key tab of the Class Survey Excel file. Make sure to check the summary statistics box. Using these measures, describe the average respondents social media usage. Hint: go back to MGT 4317 Survey.docx for the scale. In other words, how much does the average respondent use each application?
2. Compute correlations for all variables selected in #1. What are the large correlations? What does this tell you about the respondents social media behavior?
3. Create a pivot table using the variables selected in #1 and the variable, section. Then, select section as the row variable and the averages of the remaining variables as values. Finally, create a pivot chart from this data that illustrates the differences between the two sections. Based on this analysis, what are the similarities and differences between the two sections? Note: Section is the course section. My online section was 1 and Nittrouers F2F section was 2.

Last Completed Projects