Answered step by step
Verified Expert Solution
Question
1 Approved Answer
N Lomumlnbw 1o 11 12 13 14 1s 16 17 18 19 20 21 22 23 24 25 cholesterol values control 233 291 312 250
N Lomumlnbw 1o 11 12 13 14 1s 16 17 18 19 20 21 22 23 24 25 cholesterol values control 233 291 312 250 342 197 268 224 239 239 254 276 234 181 248 252 202 218 212 325 treatment 344 185 263 246 150 212 188 250 148 169 226 175 242 252 153 183 137 202 194 213 42.57658734 50.03830112 (1) USE EXCEL TO CALCULATE THE STATISTICS BELOW FOR THESE TWO SETS OF BLOOD SERUM TOTAL CHOLESTEROL MEASURES. (2) THEN TYPE THE STATISTICS INTO THE CELLS PROVIDED. (3) LASTLY, USE YOUR RESULTS TO WRITE A CONCLUSION ABOUT WHETHER THERE APPEARS TO BE A STATISTICALLY SIGNIFICANT DIFFERENCE BETWEEN THE MEANS OF THESE TWO GROUPS. (4) SUBMIT SPREADSHEET THROUGH THE WEEK 2, PART 2 FOLDER. control treatment n mean std dev t-stat p -value* *Apply a 2-sample t-test between two group means (assume these two-samples have an equal variance) Conclusion
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started