CML 11

docx

School

The University of Queensland *

*We aren’t endorsed by this school

Course

1310

Subject

Statistics

Date

Apr 3, 2024

Type

docx

Pages

1

Uploaded by EarlAntelope4213

Report
With the datafile DF1.7A  (located in a folder under the CML Quizzes tab) use Excel Data Analysis to compute the descriptive statistics for BSc (column B). From these descriptive statistics, find the numerical values of each of the following: (i) mean – 2 standard deviations (correct to 1 decimal place) [a] (ii) mean + 2 standard deviations (correct to 1 decimal place) [b] (iii) Using the empirical rule how many data points are expected to be within one standard deviation to either side of the mean (nearest whole number)?  [c] (iv) In the data file, count how many actual sample data points for BSc are within the range of one standard deviation to either side of the mean (nearest whole number)?  [d] Specified Answer for: a 30324. 9 Specified Answer for: b 53058. 4 Specified Answer for: c 34 Specified Answer for: d 32 Correct Answers for: a Evaluation Method Correct Answer Cas Exact Match 30238.9 Correct Answers for: b Evaluation Method Correct Answer Cas Exact Match 53058.4 Correct Answers for: c Evaluation Method Correct Answer Cas Exact Match 34 Correct Answers for: d Evaluation Method Correct Answer Cas Exact Match 32
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help