Hello can you please guys calculate the sum,count,mean average and standard devi

Question

Hello

can you please guys calculate the sum,count,mean average and standard deviation for me using excel

Engineering Instrumentation and Measurements Measurements on Specimen 4 Our Measurements were conducted with two instruments; the ruler and a Vernier caliper 5 All measurements wer recorded in centimetres 6 the specimen is symmetric, made in the same lab, from the same machine, by the same person as other specimens 7 Even with our equipment we wer not able to record the cruvature between bases R2 and its attached R3 and R1 borders Measurements Recorded using Ruler 2 1.65 1.55 1.55 L3 2.85 2.8 2.7 R1 3cm 3cm 3cm R2 1.6 1.65 1.8 R3 R4 0.7 0.65 0.7517 Depth 0.7 0.73 0.8 1 2 Trial One17.09 13 Trial Two17.1 4 Trial Three 17.15 L4 8.5 8.6 8.5 0.9 Measurements Recorded using Vernier Caliper 19 2 1.8 1.76 1.79 R1 R2 1.8 1.8 1.81 R3 1 21 Trial One 17.4 22 Trial Two17.25 23 Trial Three 17.3 L3 2.7 2.74 2.8 L4 8.45 8.54 8.6 R4. 0.61 0.63 0.64 Depth 0.6 0.625 0.621 25 Calculating Mean, Average & standard deviation

Explanation / Answer

following functions in excel helps to calculate sum, average and standard deviaiton

sum=SUM()

average=AVERAGE()

standard deviaiton =STDEV( )

Measurements Recorded using Ruler L1 L2 L3 L4 R1 R2 R3 R4 Depth Trail One 17.09 1.65 2.85 8.5 3 1.6 1.1 0.7 0.7 Trail Two 17.1 1.55 2.8 8.6 3 1.65 0.9 0.65 0.73 Trail Three 17.15 1.55 2.7 8.5 3 1.8 1.1 0.7517 0.8 sum 51.34 4.75 8.35 25.6 9 5.05 3.1 2.1017 2.23 average 17.11333 1.583333 2.783333 8.533333 3 1.683333 1.033333 0.700567 0.743333 st. Deviation 0.032146 0.057735 0.076376 0.057735 0 0.104083 0.11547 0.050852 0.051316 Measurements Recorded using Vernier Caliper L1 L2 L3 L4 R1 R2 R3 R4 Depth Trail One 17.4 1.8 2.7 8.45 3 1.8 1.1 0.61 0.6 Trail Two 17.25 1.76 2.74 8.54 3 1.8 1.1 0.63 0.625 Trail Three 17.3 1.79 2.8 8.6 3.1 1.81 1.1 0.64 0.621 sum 51.95 5.35 8.24 25.59 9.1 5.41 3.3 1.88 1.846 average 17.31667 1.783333 2.746667 8.53 3.033333 1.803333 1.1 0.626667 0.615333 st.Deviation 0.076376 0.020817 0.050332 0.075498 0.057735 0.005774 0 0.015275 0.013429

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.