Excel Data Analysis Tool Pack - Distinct Methods of Calculating Summary - Statistics Assignment Help

Assignment  Task :

Problem Description:

You have been appointed by the Dean of Business to analyse student performance in a course offered by the Business School. The data provided are real but not from RMIT. The focus is upon the key determinants of the Final_exam (i.e. the students’ final exam mark), in particular the role of the Assignment (i.e. Assignment_grade) and Tutorial_attend (i.e. the number of tutorials attended during the semester). Using the tools learned in your current Business Statistics course provide the Dean with an analysis of Final_exam performance. You may assume the Dean has a good understanding of basic statistics. In addition the Dean would like you to prepare a PowerPoint presentation to illustrate the key findings of your analysis to the incoming student cohort. Unlike the Dean, the cohort has not yet studied business statistics.

There are two parts to this assignment, each of which is described in detail:

Locate the data file (AssignmentBusStats.xls) on CANVAS.  

1. As shown in several lectures there are two distinct methods of calculating summary or descriptive statistics using Excel. This question requires you to use both methods. First use Excel Data Analysis Tool Pack (the descriptive statistics option) to calculate summary statistics for all variables included in the attached data file. Comment on your summary statistics including any differences across the 3 included variables, i.e. Final_exam, Assignment_mark and Tutorial_attend.  Carefully interpret. Second use excel to calculate all descriptive statistics documented in your report. These calculations should be carefully laid out in excel and should use excel formula NOT Data Analysis Toolpack. [Topic                    

2. Use appropriate graphs to interpret the relationship between

3. (i) Final_exam and assignment_grade;

4. (ii) Final_exam and Tutorial_attend; and

5. (iii) assignment_grade and Tutorial_ attend. Carefully interpret and explain. 

3. Calculate the sample correlation and covariance for the above 3 relationships in question 2. Carefully interpret your results. Once again use Excel for these calculations using both methods i.e. Data Analysis Tool Pack (options covariance, correlation) and using Excel formulae without use of Data Analysis Tool Pack. (Hint- if you find a discrepancy in your answers between the 2 excel methods can you explain why?)

4. For this question ONLY, assume that the first 26 observations are male (i.e. rows 2-27 of the original data) and the last 29 observations are female. Use Excel both with and without Data Analysis Tool Pack to test the null hypothesis that the mean of the Final_exam is equal for males and females. Interpret your results.  

5. Use simple regression to explore the relationship between

6. (i) Final_exam (Y) and assignment_grade (X);

7. (ii) Final_exam (Y) and Tutorial_attend (X). Carry out any relevant hypothesis tests using a two-tailed hypothesis test approach at the 5% significance level. You may use Data Analysis Tool Pack for this. Carefully interpret and explain.  

This Statistics Assignment has been solved by our Statistics  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.