Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

Statistics


Home >> Statistics and Probability

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 R2 value on the chart.
  • Complete the "Statistics Deliverable" and submit via the "Lab Submittals" icon in BBLearn.

Attachment:- Assignment.rar

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M91974535

Have any Question?


Related Questions in Statistics and Probability

Phillips owns 25 of mintor inc a private company in 2007

Phillips owns 25 % of Mintor, Inc. (a private company). In 2007, Mintor had sales of $22,00,000, had net income of $82,000 and Mintor paid $32,000 in dividends. If Phillips uses the Equity Income method, what did Phillip ...

Monthly water bills for a city have a mean of 10843 and a

Monthly water bills for a city have a mean of $108.43 and a standard deviation of $36.98. Find the probability that a randomly selected bill will have an amount greater than $165, which the city believes might indicate t ...

Where do cfos get their money newswhere do cfos get their

Where do CFOs get their money news? Where do CFOs get their money news? According to Robert Half International,   47% get their money news from newspapers, 15% get it from communication/colleagues, 12% get it from televi ...

A firm that produces light bulbs claims that their

A firm that produces light bulbs claims that their lightbulbs last 1500 hours, on average. You wonder if the average might differ from the 1500 hours that the firm claims. To explore this possibility you take a random sa ...

Staples has six special drafting pencils for sale two of

Staples has six special drafting pencils for sale, two of which are defective. A student buys two of these six drafting pencils, selected at random. Let the random variable X be the number of defective pencils. Construct ...

A using an hp 12c calculator what are the correct steps to

a) Using an hp 12c calculator, what are the correct steps to calculate IRR entered as monthly payments and if summed up for a year? b) Using an hp 12c calculator, what is the best way to calculate effective interest rate ...

Assume that the mean score on a normally distributed

Assume that the mean score on a normally distributed statistics quiz taken by 400 psychology students was 76, and the standard deviation was 8. Ben had a z-score of -1.2. If someone gave a passing grade only to the top 2 ...

A study was conducted to evaluate the association between

A study was conducted to evaluate the association between benzene exposure and leukemia. Employment records identified 10,000 workers who were occupationally exposed to benzene in the 1980s and 14,000 workers who were no ...

1 define organizational communication2 what interesting

1. Define organizational communication 2. What interesting about the subject of organizational communication

Question a random variable x is known to be distributed

Question: A random variable X is known to be distributed either N(1,3) or N(2,3). The mill hypothesis is that the mean is equal to 1. The alternative hypothesis is that the mean is 2. a. With a sample of 10 draws from th ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved