excel project 12

/in /by

AcademicWritersDen.com boasts a team of highly skilled and experienced writers who specialize in various academic fields. The company carefully selects its writers through a rigorous screening process to ensure that they possess the necessary qualifications and expertise. Whether it’s an essay, research paper, or any other homework assignment, students can rely on AcademicWritersDen.com to connect them with professionals who have an in-depth understanding of the subject matter. This ensures that the work delivered is of high quality and meets the academic standards set by educational institutions.

Your assignment is to prepare a report for Dr. Nicholas Wagner, Director of Institutional Research at Saginaw Valley State University. The purpose of the report is to provide Dr. Wagner some recommendations on how to improve the likelihood of student success for the freshman class at SVSU.To help with your analysis, the following file contains a real dataset collected from SVSU’s freshman students in the first two weeks after they enter the university.
Your report should contain the following sections:

  1. Student readiness analysis
    1. The dataset contains 10 measurements of student readiness for college in columns B-K. The description of each one of them is available in the file.
    2. In order to analyze this data, you need to create additional columns and recode the data, making low a 1, moderate, a 2, and High a 3 (you can use an IF function to do this). In this format, the highest the number, the more prepared the student is.
    3. Once the data is recoded, prepare a table in ascending order of the average for each of these 10 measurements.
  2. A correlation analysis.
    1. Pick the 10 measurements of students readiness and create a correlation matrix (you need to use the data analysis tools from Excel to do this, you may need to install it).
    2. Assume that a correlation greater than 0.45 is significant and use Conditional Formatting to highlight those correlations greater than 0.45.
    3. Provide a potential logical explanation why those correlations are significant.

 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.