mass v1 v2 v3 1 1.1 1.24 0.98 2 1.53 1.46 1.57 3 1.96 1.83 1.79...

mass	v1	v2	v3
1	1.1	1.24	0.98
2	1.53	1.46	1.57
3	1.96	1.83	1.79
4	2.14	2.16	2.35
5	2.4	2.52	2.5

Using excel, how do you find the t test and the chi-squared?

Solutions

Expert Solution

There are special function in excel for t test and chi squared tests. These are:

For getting the chi square value we have:

So here is an two tailed t test in excel:

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Are the vectors v1 = (1 , 2, 3), v2 = (2, 4, 6), and v3...

Are the vectors v1 = (1 , 2, 3), v2 = (2, 4, 6), and v3 = (1, 1, 3) linearly independent or dependent? Since v2 is a scalar multiple of v1, both v1 and v2 are linearly dependent, but what does that say about the linear dependence of the three vectors as a whole?

a, The vectors v1 = < 0, 2, 1 >, v2 = < 1, 1, 1...

a, The vectors v1 = < 0, 2, 1 >, v2 = < 1, 1, 1 > , v3 = < 1, 2, 3 > , v4 = < -2, -4, 2 > and v5 = < 3, -2, 2 > generate R^3 (you can assume this). Find a subset of {v1, v2, v3, v4, v5} that forms a basis for R^3. b. v1 = < 1, 0, 0 > , v2 = < 1, 1, 0 > and v3...

#1 Let H= Span{v1,v2,v3,v4}. For each of the following sets of vectors determine whether H is...

#1 Let H= Span{v1,v2,v3,v4}. For each of the following sets of vectors determine whether H is a line, plane ,or R3. Justify your answers. (a)v1= (1,2,−2),v2= (7,−7,−7),v3= (16,−12,−16),v4= (0,−3,−3) (b)v1= (2,2,2),v2= (6,6,5),v3= (−16,−16,−14),v4= (28,28,24) (c)v1= (−1,3,−3),v2= (0,0,0),v3= (−2,6,−6),v4= (−3,9,−9) #2 Plot the linesL1: x= t[4−1] and L2: x= [−4−2] + t[4−1] using their vector forms. If[12k]is onL2. What is the value of k?

True or False. 1. If the set {v1,v2} is a basis of R^2, then the set...

True or False. 1. If the set {v1,v2} is a basis of R^2, then the set {v1,v1+v2} is also a basis of R^2. 2.If W be a vector space and V1,V2 are subspaces of W, then V1 u V2 is also a subspace of W. V1 u V2 denotes the union of V1 and V2, i.e. the set of vectors which belong to either V1 or V2 (or to both). 3.If W be a vector space and V1,V2 are subspaces...

1.) Find the sum V in cartesian and polar coordinates of V1=1000 m/s, V2=1800 m/s 2.)...

1.) Find the sum V in cartesian and polar coordinates of V1=1000 m/s, V2=1800 m/s 2.) Find the difference of V in polar and cartesian coordinates for V3= 800 m/s and V4= 1400 m/s. The angles are angle1= 35 deg, angle2= 60 deg, angle3= 130 deg, angle4= 340 deg.

1.let {v=(1,2,3,5,9),v2=(3,1,2,8,9),v3=(2,-5,5,9,4)} and {u1=(0,1,1,1,2),u2=(0,2,-2,-2,0)} be basis of subspaces V and U of R5 respectively.find a basis...

1.let {v=(1,2,3,5,9),v2=(3,1,2,8,9),v3=(2,-5,5,9,4)} and {u1=(0,1,1,1,2),u2=(0,2,-2,-2,0)} be basis of subspaces V and U of R5 respectively.find a basis and the dimension of V+U and V intersection U. 2.does a matrix have a right inverse ?if so find one A=[2,-3,-7,11;3,-1,-7,13;1,2,0,2] 3.find the interpolating polynomial that passes through the point (1,2),)(-1,-8) and (2,1)

Case taste Acetic H2S Lactic 1 12.3 4.543 3.135 0.86 2 20.9 5.159 5.043 1.53 3...

Case taste Acetic H2S Lactic 1 12.3 4.543 3.135 0.86 2 20.9 5.159 5.043 1.53 3 39 5.366 5.438 1.57 4 47.9 5.759 7.496 1.81 5 5.6 4.663 3.807 0.99 6 25.9 5.697 7.601 1.09 7 37.3 5.892 8.726 1.29 8 21.9 6.078 7.966 1.78 9 18.1 4.898 3.85 1.29 10 21 5.242 4.174 1.58 11 34.9 5.74 6.142 1.68 12 57.2 6.446 7.908 1.9 13 0.7 4.477 2.996 1.06 14 25.9 5.236 4.942 1.3 15 54.9 6.151 6.752 1.52...

A disk with a c value of 1/2, a mass of 3 kg, and radius of...

A disk with a c value of 1/2, a mass of 3 kg, and radius of 0.29 meters, rolls without slipping down an incline with has a length of 6 meters and angle of 30 degrees. At the top of the incline the disk is spinning at 28 rad/s. How fast is the disk moving (the center of mass) at the bottom of the incline in m/s?

1.1 Write the importance of subject 1. Intercultural competencies 2. Linguistic 3. Public relations 1.2 Explain...

1.1 Write the importance of subject 1. Intercultural competencies 2. Linguistic 3. Public relations 1.2 Explain corporate social responsibility: Explain corporate social responsiblity and the public relations practitioner's involvement in it. Describe the various ways PR practitioners might be in cause of PR . 1.3 Writing for PR: explain the importance of defining the audience and key messages prior to writing any communications materials; Outline the different news hooks and explian why they are inportant to PR writing ; Describe...

how can i Calculate those ?? 1)Mass of Cu wire reacted 2)Mass of Ag produced 3)Mass...

how can i Calculate those ?? 1)Mass of Cu wire reacted 2)Mass of Ag produced 3)Mass of AgNO3 reacted 4)Moles of Cu reacted 5)Moles of AgNO3 reacted 6)Moles of Ag produced 7)Ratio of moles Ag to moles AgNO3 8)Ratio of moles Ag to moles Cu 9)Number of Cu atoms removed from wire 10)Number of Ag atoms produced 11)Theoretical yield of Ag 12)% Yield of Ag

Subjects