T-test statistics and descriptive statistics

Assignment Help Mechanical Engineering
Reference no: EM131070384

Assignment 2: RA 1: t-Tests

Working with Data in Microsoft Excel

Once again, reading about t-test statistics and descriptive statistics is one thing. Actually using software to compute them requires different skill sets. This assignment is designed to give you the opportunity to practice using Microsoft Excel to compute a t-test and to reinforce your learning of computing descriptive statistics from a previous module. A data set has been presented below for you to use to conduct your analyses. The data set represents the scores from five students who were tested on the same material using three different forms of the test.

Name Test 1 Test 2 Test 3
Lyle 88 92 89
Jorge 78 82 78
Kim 34 87 62
Frances 76 82 32
Tomeca 66 88 64
  • Enter the above data into Microsoft Excel.
  • Using Microsoft Excel, compute the mean for each test, each student, and the sample overall.
  • Using Microsoft Excel, compute the standard deviation for each test, each student, and the sample overall.
  • Using Microsoft Excel, create a correlation table for Test 1, Test 2, and Test 3. Interpret the results.
  • Conduct a t-test to see if there is a significant difference in scores between Test 1 and Test 2. Interpret the results.
  • Include a printout of your Microsoft Excel computations with your paper submission.
  • Explain the concepts of central tendency, variance, standard deviation, correlation, and the difference between the means of two groups.
  • Include a description of the computations you conducted on the data provided for this assignment and your interpretation of the results of your computations. What do you know about this data set? What is something that you do not yet know about this data?

Your final product should include the Microsoft Excel computations and a 3- to 5-page Microsoft Word document, utilizing a minimum of three scholarly sources. Make sure you employ proper grammar and spelling and apply current APA standards for writing style to your work.

Use the following headings and subheadings to organize your paper:

  • Defining and explaining concepts
    • Central tendency
    • Variance
    • Standard deviation
    • Correlation
    • Difference between two group means
  • Computation results
    • Mean
      • Tests
      • Students
      • Overall sample
    • Standard deviation
      • Tests
      • Students
      • Overall sample
    • Correlation for the three tests
    • t-test between Test 1 and Test 2
  • Discussion of results
  • References
  • Appendix (Microsoft Excel printout)

Reference no: EM131070384

Questions Cloud

Clarity of methods and assumptions : Application of relevant course concepts, tools and frameworks use of evidences, engagement with the literature.
Find the clients living in kansas city : Find the clients living in Kansas City. Include the client's Client No., Clast name, Cfirst name, Caddress, the name(s) of their pet(s), and their respective Quoted Prices. Save the query as CLIENTS in KANSAS CITY.
Impact of branding in sales or organisational development : RESEARCH IN BUSINESS ASSIGNMENT - Impact of Branding in Sales or Organisational development. Impact of Branding on the business. The Revenue patterns of the company with a branding
Appear in the system emission spectrum : The allowed energies of a quantum system are 1.0 eV , 2.0 eV , 4.0 eV , and 7.0 eV . What wavelengths appear in the system's emission spectrum?
T-test statistics and descriptive statistics : This assignment is designed to give you the opportunity to practice using Microsoft Excel to compute a t-test and to reinforce your learning of computing descriptive statistics from a previous module.
Weight of a plastic sphere of mass : What is the magnitude of a the vertical electric field that will balance the weight of a plastic sphere of mass that has been charged to -3.0 nC? (k = 1/4πε0 = 9.0 × 109 N · m2/C2)
What do the terms inverting and non-inverting mean : Calculate the ideal IT, IE,Vc for the differential amplifier shown in the diagram. Repeat the calculations using the second approximation. Show all work and record the final answers in the table.
Right thickness for canceling red light : Suppose the thickness of an oil film on water is just the right thickness for canceling red light. what color would your eye see? Why?
Applications of multirate digital signal processing : ELEC 0316-SPRING - Discuss the applications of Multirate Digital Signal processing or Explain the need of Multirate Signal Processing with suitable Example.

Reviews

Write a Review

 

Mechanical Engineering Questions & Answers

  The glass surfaces may be treated with a low-emissivity

a double-glazed window consists of two panes of glass each of thickness t 6 mm. the inside room temperature is ti 293

  At what distance must the cheetah relative to the antelope

zoologists estimate that the average adult cheetah can run at a speed of 100 kmhr and that the average antelope can run

  The two pipes are said to be equivalent

A compound pipe is required to be replaced by a new pipe. The two pipes are said to be equivalent

  Determine radial and tangential stresses as functions of r

two hollow metal cylinders are to be press-fitted together. the outer steel member has outer and inner diameters of

  Is the flow laminar or turbulent justify your answer what

a 10 cm2 plate has an electric heater installed that produces a constant heat flux. saturated liquid water at 10 degc

  The horizontal force moves the 3 kg package up a smooth

the horizontal force moves the 3 kg package up a smooth hill whose profile is given by y x24 where x and y are in

  The camera speed was 20 frames per second plot the

the displacement of a point on a moving body was measured in each frame of a motion-pcture film. the displacements

  A long spring with a k50 lbin is cut into three equal

a long spring with a k50 lbin is cut into three equal parts. the resulting springs are connected to a 386 lb block as

  Determine the coefficient of static friction

Determine the force P required to force the 10° wedge under the 90-kg uniform crate which rests against the small stop at A. The coefficient of friction for all surfaces is 0.40.

  Determine the critical value wcr of the load

Determine the critical value Wcr of the load.

  Find the maximum load on bevel gear and shaft

You have a bevel gear and shaft and you have to find the maximum load that can be applied on it.

  A civil engineer must design a wheelchair accessible ramp

a civil engineer must design a wheelchair accessible ramp next to a set of steps leading up to a building. the height

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd