Calculate the average quiz score

Assignment Help Basic Statistics

Reference no: EM131218576

Statistics Submittal-

The objective of this Submittal is to examine the relationships with students' grades in CENE 253L Mechanics of Materials Laboratory.

To accomplish this goal, perform the following operations on the attached Excel data:

Calculate the average Quiz Score [i.e. (points earned)/(points available)] for each student
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% Quiz, 70% Lab Reports]
Calculate the Maximum Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students.
Calculate the Mean Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students
Calculate the Median Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students.
Calculate the Standard Deviation Quiz Ave., Lab Report Ave., Class Quiz Ave., and Cumulative Ave. for all students
Create three separate x-y scatter plots in Excel: 1) 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 R² value on the chart.
Complete the "Statistics Deliverable" and submit via the "Lab Submittals" icon in BBLearn.

Attachment:- Assignment.rar

Reference no: EM131218576

Questions Cloud

Equation for the balance condition : As a decision maker in this firm, what would you do in the short term to improve the firm's condition and how might you do it? Be sure to include the equation for the balance condition in your response.

What is the wage when labor demanded : Provide answers to each of the following based on LD = 500 - 20W 1. What is the wage when labor demanded is equal to 220? 2. What is the labor demanded when the wage is equal to $17?

Canceling price supports for all agricultural producers : The government is considering canceling price supports for all agricultural producers. This policy will hurt the farmers whose products have a (low / high) _________ own price elasticity of demand and a (low / high) _________ price elasticity of m..

Growth of per capita income : 1) In defining development to include more than just the growth of per capita income, there is an implicit assumption that the growth of per capita income alone is not sufficient to guarantee the reduction of poverty and the growth of self-esteem.

Calculate the average quiz score : To accomplish this goal, perform the following operations on the attached Excel data: Calculate the average Quiz Score [i.e. (points earned)/(points available)] for each student and Calculate the average Lab Report Score [i.e. (points earned)/(points..

Combination of steel and aluminum : Peter owns an auto parts firm. He uses a combination of steel and aluminum to produce her auto parts. All of the following combinations will finish the task on time. Steel costs $15 per unit and the aluminum costs $50 per unit. What combination of..

Maximizes utility subject to his budget constraint : Rafael has the utility function U = x · y with the marginal utilities MUx = y and MUy = x.The price of x is 2, the price of y is unknown and equal to the variable py, and his income is$40. When Rafael maximizes utility subject to his budget constr..

Company benefits from economies of scale : A company produces 1,000 soccer balls each day, which it sells to customers for $25 each. All costs associated with production and sales total $12,500; however, if the company were to produce one additional soccer ball per day, total costs would i..

Design an active rc circuit with the transfer function : Use a frequency analysis PSpice to plot the frequency response o the transfer function magnitude s indicated Plot at least one decade above and below an corner frequency

User Account

All Pages