Question

In: Statistics and Probability

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:


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?
consider the vectors: v1=(1,1,1) v2=(2,-1,1) v3=(3,0,2) v4=(6,0,4) a)find the dimension and a basis W=Span(v1,v2,v3,v4) b) Does...
consider the vectors: v1=(1,1,1) v2=(2,-1,1) v3=(3,0,2) v4=(6,0,4) a)find the dimension and a basis W=Span(v1,v2,v3,v4) b) Does the vector v=(3,3,1) belong to W. Justify your answer c) Is it true that W=Span(v3,v4)? Justify your answer
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT