H 5 BEG2080 2017 Assignment 1 Worksheet Excel Insert Draw Page Layout Formulas D

Question

H 5 BEG2080 2017 Assignment 1 Worksheet Excel Insert Draw Page Layout Formulas Data Review view Q Tell me what you want to do File Home d Cut E Wrap Text General Copy Paste Conditional Format as B I U e & C M Format Painter Formatting Table Styles Clipboard Fon Alignment Number B36 18 Q3.1 A MEAN VALUES 20 Q3.1 A MEDIAN VALUES L 3.30 L 4670 125.0 22 Q3.1 A MODE VALUES L 1.60 L 4670 152.00 24. Q3.1 A MIDRANGES> 5.05 394 137.0 63995 58.33 27 Q3.1 D STANDARD DEV 3.56 31 Q3.1 F COEFFICIENT OF VARIATION 0.79 0.45 35 Enter your written answer in the boxes below L 36 Q3.1 B Part I Part II Part III Part IV I Part V I Part VI Edit x B Type here to search BE BE hasina naseer X Share Autosu A Format Find Clear Select Editing 2:13 PM ENG 2017-06-13

Explanation / Answer

A)

AVERAGE (X:X), MEDIAN (X:X), MODE (X:X).

B)

AVPRECIP looks to be more skewed towards the right because the last two numbers seem to be outliers.

C)

In case we want to test the hypothesis about comparing population (regional) means with sample means, we can do that.

D)

STDDEV.S(X:X)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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