There are a word (outline), and grade data files provided ( will be attached ). This lap report has several questions and some graphs. There are no specific amount of words, that’s why I do not know how much pages should I order.
Calculate the average Online Quiz Score [i.e. (points earned)/(points available)] for each student.
My roommates used almost
Calculate the average Lab Report Score [i.e. (points earned)/(points available)] for each student
Calculate the average Class Quiz Score [i.e. (points earned)/(points available)] for each student
Calculate the Cumulative Average for each student based on the following weighted scale: [10% Class Quiz, 20% online Quiz, 70% Lab Reports]
Calculate the Maximum online Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students.
Calculate the Minimum online Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students.
Calculate the Mean online Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students
Calculate the Median online Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students.
Calculate the Standard Deviation online Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students
Create three separate x-y scatter plots in Excel: 1) online Quiz Ave. versus Cumulative Ave.; 2) Lab Report Ave. versus Cumulative Ave.; and 3) Class Quiz Average versus Cumulative Average
For the three plots, add a linear trendline. Display the equation and R2 value on the chart