Скачать или смотреть Exp22_Excel_Ch08_ML1_Course Evaluation | Excel Ch08 ML1 Course Evaluation | excel Ch08 ML1 Course

Exp22_Excel_Ch08_ML1_Course Evaluation | Excel Ch08 ML1 Course Evaluation | excel Ch08 ML1 Course

Contact us:

WhatsApp : +92 3260782026

WhatsApp Link:
https://bit.ly/3pIuXPl

Gmail : [email protected]

We can handle all online courses, Business and Management, Business and Finance, MylTLab all Courses

Project Description:
You are a data analyst for a local university. At the end of each academic semester, you perform statistical analysis on student course evaluations. You want to analyze the results by calculating basic descriptive statistics. You also want to check for a correlation between student GPA and course opinion. La

Start Excel. Download and open the file named Exp22_Excel_Ch08_ML1_CourseEvaluation.xlsx. Grader has automatically added your last name to the beginning of the filename.
Use the FREQUENCY function in the range H5:H9 to calculate the frequency distribution of course evaluations from the range D4:D35 based on the frequency bins located in the range G5:G9.
Use the STDEV.S function to calculate the standard deviation between the current values of all course ratings in cell H12.
Use the VAR.S function to calculate the variance between the current values of course ratings in cell H13.
Use the CORREL function in cell G17 to calculate the correlation between GPA in the range C4:C35 and course evaluation in the range D4:D35.
Ensure the Analysis ToolPak is loaded. Create a descriptive statistics summary based on the course evaluations in column D. Ensure labels and summary statistics are included. Display the output in cell G19.
Insert a scatter plot with course rating as the x axis values and GPA as the y axis values. Be sure to add appropriate chart and axis labels.
Add a linear trend line to the scatter plot with the equation and R-square displayed on the chart.
Position the chart so the upper-left corner is in cell J4 and move the equation displayed on the chart to the upper-left corner of the plot area.
Insert a box and whisker chart based on the GPA values located in column C. Add an appropriate chart title and delete the x axis label. Place the chart so the upper-left corner is in cell J19.
Insert a histogram based on course ratings located in column D. Add an appropriate chart title and position the chart so the upper-left corner is in cell R4.
Save and close Exp22_Excel_Ch08_ ML1_CourseEvaluation.xlsx. Exit Excel. Submit the file as directed.


#Exp22_Excel_Ch08_ML1_Course Evaluation | Excel Ch08 ML1 Course Evaluation
#Exp22_Excel_Ch08_ML1_Course Evaluation
#Exp22_Excel_Ch08_ML1_Course
#Exp22_Excel_Ch08_ML1
#Exp22_Excel_Ch08
#Excel Ch08 ML1 Course Evaluation
#Excel Ch08 ML1 Course
#Excel Ch08 ML1
#Excel Ch08
#excel Ch08 ML1 Course
#excel Ch08 ML1
#excel Ch08