MAT 144 Topic 5 DQ 1 скачать в хорошем качестве

MAT 144 Topic 5 DQ 1

📊 MAT-144 – Topic 5 DQ 1: Descriptive Statistics and the Empirical Rule In this video, Professor Ragsdale walks you through Topic 5 DQ 1, where you’ll use Excel to analyze data from a water treatment study. You’ll calculate key descriptive statistics and use the Empirical Rule to interpret how effective the treatment is in reducing bacteria levels. ------- CHAPTERS: 0:00 Intro 0:10 Chapter 1-Entering Data & Stats 3:52 Chapter 2- Analyzing Percentiles 6:49 Chapter 3- Interpreting Results -------- You’ll learn how to: ✅ Use Excel formulas to find the mean, median, standard deviation, and range for “before” and “after” treatment data ✅ Calculate improvement data using cell references (After – Before) ✅ Compute the 16th and 84th percentiles using Excel’s built-in functions ✅ Apply the Empirical Rule (68%) to find upper and lower bounds of improvement ✅ Interpret the results to evaluate the effectiveness of the water treatment 💡 Tip: Format all calculated results as Numbers with two decimals, and use cell references rather than typing numbers directly into formulas to keep your work dynamic. 📘 Concepts Covered: Mean, median, standard deviation, and range Percentiles and the Empirical Rule Interpreting data distributions Real-world application of statistics to environmental data 🗓️ Reminder: Post your completed Excel file and written summary in the main DQ 1 thread in Halo — not in the walkthrough post — to receive credit.