Underlined topics are singled out as extremely important to understand.<br>
These are the topics that usually give students a hard time, but are
essential to understand the rest<br> of the material!<br><br>

<font color=red><b>You don't have to type the data by hand for software homework problems.</b></font><br>
Here's where you can find <a href=Excel>excel files</a> with data in them, 
for the software homework problems. Go to<br> the folder with the appropriate chapter
number, then to the appropriate exercise. Sometimes, the<br> exercise is 
not there, but that's because the data is from a table. So then look for
the appropriate table.<br><br>

Here is the <a href=Formulas_Final.pdf>formula sheet</a> 
that you will have during exams.<br>
It also has the necessary tables that appear in the book.<br><br>

<table border=1>
<colgroup span=1 width=184>
<colgroup span=1 width=450>
<tr>
<td><b>Week 1<br> January 10, 12, 14</b></td>
     <td>Chapter 1 - <i>What is statistics, individuals and variables, type of variables, distributions and their representations (pie charts, bar graphs, histograms, time plots) (stem plots are skipped)</i><br>
<a href=Chapter_01.ppt>[powerpoint]</a> <a href=Chapter_01.pdf>[pdf]</a><br><br>
     Chapter 2 - <i><u>Numerical summary of a distribution</u> (mean, median, quartiles, boxplot, outliers, variance and standard deviation)</i><br>
(Homework is essential for understanding.)<br>
<a href=Chapter_02.ppt>[powerpoint]</a> <a href=Chapter_02.pdf>[pdf]</a><br><br>
[No Homework this week]
</td>
</tr>
<tr>
<td><b>Monday, January 17</b></td>
     <td>MARTIN LUTHER KING DAY</td>
</tr>
<tr>
<td><b><font color=red>Wednesday, January 19</font></b></td>
     <td><font color=red>Last day to drop</font></td>
</tr>
<tr>
<td><b>Week 2<br> January 19, 21</b></td>
     <td>Chapter 2 - <i><u>Numerical summary of a distribution</u> (mean, median, quartiles, boxplot, outliers, variance and standard deviation)</i><br>
(Homework is essential for understanding.)<br>
<a href=Chapter_02.ppt>[powerpoint]</a> <a href=Chapter_02.pdf>[pdf]</a><br><br>
     Excel - <i>Using Excel: entering data, saving files, 
drawing pie charts, etc, computing means, medians, etc.</i> (SUM, AVERAGE, MEDIAN, QUARTILE, MIN, MAX, STDEV, SQRT, FREQUENCY)<br>
Exercises: 
<a href=Excel/ch01/eg01-02.xls>1.2</a>,
<!-- <a href=Excel/ch01/ex01-25.xls>1.25</a>,
<a href=Excel/ch01/ta01-05.xls>1.35</a>, 
<a href=Excel/ch01/ex01-45.xls>1.45</a>, -->
<a href=Excel/ch01/ex01-12.xls>1.12</a>,
<a href=Excel/ch02/ex02-31.xls>2.31</a>,
<a href=Excel/ch02/ex02-35.xls>2.35</a>, <!-- 2.39, 2.41, -->
<!-- <a href=Excel/ch02/ta02-02.xls>2.43</a>,  -->
<a href=Excel/ch02/ta02-03.xls>2.45</a>. 
<br>
Solutions:
<a href=Excel/ch01/eg01-02-solution.xls>1.2</a>,
<!-- <a href=Excel/ch01/ex01-25-solution.xls>1.25</a>,
<a href=Excel/ch01/ta01-05-solution.xls>1.35</a>,
<a href=Excel/ch01/ex01-45-solution.xls>1.45</a>, -->
<a href=Excel/ch01/ex01-12-solution.xls>1.12</a>,
<a href=Excel/ch02/ex02-31-solution.xls>2.31</a>,
<a href=Excel/ch02/ex02-35-solution.xls>2.35</a>,
<!-- <a href=Excel/ch02/ta02-02-solution.xls>2.43</a>,  -->
<a href=Excel/ch02/ta02-03-solution.xls>2.45</a>. <br><br>
<a name="tutorials"></a>
<a href="http://www.youtube.com/watch?v=yERDgEs_c4E">[Basic Excel Tutorial]</a>
<a href="http://www.youtube.com/watch?v=XmSp2-Fa4rg">[Excel Basics]</a>
<a href="http://www.youtube.com/watch?v=jDogLgKTRf8&NR=1">[Keyboard Shortcuts]</a><br>
<a href="http://www.youtube.com/watch?v=D9wx_-pOgOc">[Copy and Paste]</a>
<a href="http://www.youtube.com/watch?v=_ABHR3R-Zbk&NR=1">[Formulas and Copying]</a>
<a href="http://www.youtube.com/watch?v=TfdmVSVul5w&NR=1">[Functions]</a>
<a href="http://www.youtube.com/watch?v=rIyUnjarqJ8&NR=1">[Range]</a>
<a href="http://www.youtube.com/watch?v=PbRQBse3Ob0">[Freezing]</a>
<a href="http://www.youtube.com/watch?v=NmVMjQzseLA&NR=1">[Locking]</a>
<a href="http://www.youtube.com/watch?v=2JlvyV7qpbk&NR=1">[Copy/Cut Formulas]</a>
<a href="http://www.youtube.com/watch?v=HVX2tAHq_J0&NR=1">[Charts]</a>
<a href="http://www.youtube.com/watch?v=qwx_h6DlypU&NR=1">[Charts 2]</a><br>
<a href="http://www.youtube.com/watch?v=TSwaU1w2NqY&NR=1">[Pie Charts]</a>
<a href="http://www.youtube.com/watch?v=o5p6Zipvdjg">[Histograms]</a>
<a href="http://www.youtube.com/watch?v=gU3ylTnvcog&NR=1">[Printing]</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 1 (due Monday January 24)]</b></a><br>
<!--<a href=HW/hw1-solutions.pdf><b>[Homework 1 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Week 3<br>January 24, 26, 28</b></td>
     <td>Chapter 3 - <i>Normal curve, area under curve, reverting to standard normal,
     <u>Finding normal proportions, finding normal percentiles</u></i><br>
<a href=Chapter_03.ppt>[powerpoint]</a> <a href=Chapter_03.pdf>[pdf]</a><br><br>
     Excel - <i>Normal computations</i> (NORMSDIST, NORMSINV)<br>
Exercies: 3.27, 3.29, 3.31, 3.37, 3.39, <a href=Excel/ch03/ex03-49.xls>3.49</a><br>
Solutions: <a href=Excel/ch03/ch03-solution.xls>3.27-3.39</a>, <a href=Excel/ch03/ex03-49-solution.xls>3.49</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 2 (due Monday January 31)]</b></a><br>
<!--<a href=HW/hw2-solutions.pdf><b>[Homework 2 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Week 4<br>January 31<br>February 2, 4</b></td> 
     <td>Chapter 4 - <i>Explanatory and response variables, scatter plots, association, correlation</i><br>
<a href=Chapter_04.ppt>[powerpoint]</a> <a href=Chapter_04.pdf>[pdf]</a><br><br>
     Excel - <i>Computing correlation and plotting scatter plots</i> (CORREL)<br>
Exercises: <a href=Excel/ch04/ex04-27.xls>4.27</a>,
<a href=Excel/ch04/ex04-29.xls>4.29</a>,
<a href=Excel/ch04/ta04-02.xls>4.31</a>,
<a href=Excel/ch04/ex04-33.xls>4.33</a>.
<br>
Solutions: <a href=Excel/ch04/ex04-27-solution.xls>4.27</a>,
<a href=Excel/ch04/ex04-29-solution.xls>4.29</a>,
<a href=Excel/ch04/ta04-02-solution.xls>4.31</a>,
<a href=Excel/ch04/ex04-33-solution.xls>4.33</a>.<br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 3 (due Monday February 7)]</b></a><br>
<!--<a href=HW/hw3-solutions.pdf><b>[Homework 3 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Week 5<br> February 7, 9, 11</b></td> 
     <td>Chapter 5 - <i>Regression, linear regression, least squares, error,
     Residuals, outliers, caution of linear regression</i><br> <!--Feb 4, 7-->
<a href=Chapter_05.ppt>[powerpoint]</a> <a href=Chapter_05.pdf>[pdf]</a> <br><br>
     Excel - <i>Find regression line, interpret it, and apply to prediction</i><br>
(SLOPE, INTERCEPT, FORECAST, Trend Line)<br>
Exercises: <!-- 5.27, 5.31, 
<a href=Excel/ch05/ex05-35.xls>5.35</a>, 
5.38, 5.40, 5.47, -->
<a href=Excel/ch05/ex05-53.xls>5.53</a> 
<br>
Solutions:
<!-- <a href=Excel/ch05/ex05-35-solution.xls>5.35</a>, -->
<a href=Excel/ch05/ex05-53-solution.xls>5.53</a> <br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 4 (due Monday February 14)]</b></a><br>
<!--<a href=HW/hw4-solutions.pdf><b>[Homework 4 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Week 6<br>February 14, 16, 18</b></td>  
     <td>Chapter 8 - <i><u>Population vs. sample</u>, simple random samples, sampling issues, <u>inference from sample to population</u></i><br>
<a href=Chapter_08.ppt>[powerpoint]</a> <a href=Chapter_08.pdf>[pdf]</a> <br><br>  <!--Feb 9-->
     Chapter 9 - <i>Collecting data: observing vs. experimenting</i><br>
<a href=Chapter_09.ppt>[powerpoint]</a> <a href=Chapter_09.pdf>[pdf]</a><br><br>  <!--Feb 11-->
     <!-- Excel - <i>Randomization</i> (RAND)<br>
Exercises: <!- 8.25, ->
<a href=Excel/ch08/ex08-27.xls>8.27</a><!- ,
8.38, 9.37 -><br>
Solutions: 
<a href=Excel/ch08/ex08-27-solution.xls>8.27</a><br><br>-->
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 5 (due Wednesday February 23)]</b></a><br>
<!--<a href=HW/hw5-solutions.pdf><b>[Homework 5 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Monday, February 21</b></td>
     <td>PRESIDENT'S DAY (office hour moved to Wednesday, same time)</td>
</tr>
<tr>
<td><b>Week 7<br>February 23, 25</b></td>
     <td>Chapter 10 - <i>What is probability theory about, relative frequency, probability rules (between 0 and 1, sums up to 1, disjoint events, complements) (clarify typical switching between probabilities and percentages)</i><br>
<a href=Chapter_10.ppt>[powerpoint]</a> <a href=Chapter_10.pdf>[pdf]</a><br><br>
     Chapter 11 - <i><u>Parameters, statistic, sampling distribution</u> (using sample mean as concrete example),
     The law of large numbers, <u>sampling distribution, mean and variance of sample mean</u>, central limit theorem</i><br>
<a href=Chapter_11.ppt>[powerpoint]</a> <a href=Chapter_11.pdf>[pdf]</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 6 (due Friday March 4)]</b></a><br>
<!--<a href=HW/hw6-solutions.pdf><b>[Homework 6 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b><font color=red>Monday, February 28</font></b></td>
     <td><font color=red>Exam 1</font> - <i>Chapters 1-8</i> (office hour moved to Wednesday, same time)<br>
<a href=Midterm1-S11.pdf>[Copy]</a> <br>
<!-- <a href=Midterm1-practice-01.pdf>[Practice]</a> 
<a href=Midterm1-practice-01-answers.pdf>[Answers]</a>  -->
<!-- [Solutions (Sep 25 afternoon)] -->
<a href=Midterm1-TakeHome-S11.pdf><font color=red>[Take-home] (Due Wednesday March 2)</font></a>
</td>
</tr>
<tr>
<td><b>Week 8<br>March 2, 4</b></td>
     <td>Chapter 11 - <i><u>Parameters, statistic, sampling distribution</u> (using sample mean as concrete example),
     The law of large numbers, <u>sampling distribution, mean and variance of sample mean</u>, central limit theorem</i><br>
<a href=Chapter_11.ppt>[powerpoint]</a> <a href=Chapter_11.pdf>[pdf]</a><br><br>
     Chapter 14 - <i>What is inference, <u>point estimate vs. confidence interval</u></i><br>
     Chapter 15 - <i>z-score and confidence interval for the mean</i><br> 
     Chapter 14 - <i><u>What a confidence interval means</u></i><br>
<a href=Chapter_14-15.ppt>[powerpoint]</a> <a href=Chapter_14-15.pdf>[pdf]</a> <br><br>
<a href="http://bcs.whfreeman.com/bps5e/content/cat_010/applets/confidenceinterval.html" target=_blank>[Confidence Interval Applet]</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 7 (due Monday March 7)]</b></a><br>
<!--<a href=HW/hw7-solutions.pdf><b>[Homework 7 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b><font color=red>Friday, March 4</font></b></td>
     <td><font color=red>Last day to withdraw</font>
</td>
</tr>
<tr>
<td><b>Week 9<br> March 7, 9, 11</b></td>
     <td>Chapter 15 - <i><u>What is a test of significance (null, alternate, p-value, CONCLUSION) (one-sided vs. two-sided), z-test</u>,
    <u>Confidence interval vs. hypothesis testing</u>, conditions for inference, caution, alpha-significance vs. p-value</i><br>
<a href=Chapter_14-15.ppt>[powerpoint]</a> <a href=Chapter_14-15.pdf>[pdf]</a> <br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 8 (due Monday March 14)]</b></a><br>
<!--<a href=HW/hw8-solutions.pdf><b>[Homework 8 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Week 10<br>March 14, 16, 18</b></td>
     <td>Chapter 17  - <i>Conditions for inference, t-score and t-test</i><br>
<a href=Chapter_17.ppt>[powerpoint]</a> <a href=Chapter_17.pdf>[pdf]</a><br><br>
     Chapters 14-17  - <i>Putting it all together: CI or test of significance?, z or t?, steps?, CONCLUSION</i><br><br>
<!-- Exercises: 10.33, 10.35, 10.39, 11.23, 11.25, 11.27, 11.31<br>-->
     Excel - <i>z-score, t-score, p-values</i> (NORMSDIST, NORMSINV, TDIST, TINV)<br>
Exercises: <!-- 11.26, 14.35, 14.37, 14.38, 
14.35, 14.41, -->
<a href=Excel/ch17/ex17-39.xls>17.39</a>,
<a href=Excel/ch14/ex14-51.xls>14.51</a>,
<a href=Excel/ch14/ex14-53.xls>14.53</a><!--,
14.43, 14.45, 14.49, 15.41<br> -->
     <!-- Excel - <i>z-score, t-score, p-values</i><br>
Exercises: -->
<a href=Excel/ch16/ex16-44.xls>16.44</a>,
<a href=Excel/ch16/ex16-47.xls>16.47</a>,
<a href=Excel/ch17/ex17-31.xls>17.31</a><br>
Solutions:
<a href=Excel/ch17/ex17-39-solution.xls>17.39</a>,
<a href=Excel/ch14/ex14-51-solution.xls>14.51</a>,
<a href=Excel/ch14/ex14-53-solution.xls>14.53</a>,
<a href=Excel/ch16/ex16-44-solution.xls>16.44</a>,
<a href=Excel/ch16/ex16-47-solution.xls>16.47</a>,
<a href=Excel/ch17/ex17-31-solution.xls>17.31</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 9 (due Monday March 28)]</b></a><br>
<!--<a href=HW/hw9-solutions.pdf><b>[Homework 9 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>March 21, 23, 25</b></td><td> SPRING BREAK</td></tr>
<tr>
<td><b>Week 11<br>March 28, 30<br>April 1</b></td>
     <td>Chapter 18 - <i>Two-sample tests for sample mean</i><br>
<a href=Chapter_18.ppt>[powerpoint]</a> <a href=Chapter_18.pdf>[pdf]</a><br><br>
     Chapter 19 - <i><u>Proportion vs. sample mean</u>, inference, confidence interval, sample size</i><br>
<a href=Chapter_19.ppt>[powerpoint]</a> <a href=Chapter_19.pdf>[pdf]</a><br><br>
[No Homework this week]
</td>
</tr>
<tr>
<td><b>Week 12<br>April 4, 6, 8</b></td>
     <td>Chapter 19 - <i><u>Proportion vs. sample mean</u>, inference, confidence interval, sample size</i><br>
<a href=Chapter_19.ppt>[powerpoint]</a> <a href=Chapter_19.pdf>[pdf]</a><br><br>
     Excel - <i>z-score, t-score, p-values</i><br>
Exercises: <!-- 18.25,-->
<a href=Excel/ch17/ex17-41.xls>17.41</a>, <!-- <br>
Exercises: 17.17, 17.29, -->
<a href=Excel/ch17/ex17-33.xls>17.33</a>,
<!-- 17.37c, -->
<a href=Excel/ch17/ta17-05.xls>17.45</a>,
<a href=Excel/ch18/ex18-37.xls>18.37</a>, 19.25, 19.41, 19.44<!--,
19.25, 19.41--><br>
Solutions: 
<a href=Excel/ch17/ex17-41-solution.xls>17.41</a>,
<!-- Solutions: -->
<a href=Excel/ch17/ex17-33-solution.xls>17.33</a>,
<a href=Excel/ch17/ta17-05-solution.xls>17.45</a>,
<a href=Excel/ch18/ex18-37-solution.xls>18.37</a><br><br>
     Chapter 22 - <i>Two-way tables, conditional distributions, <u>chi-square test</u>,
     Chi-square requirements, goodness-of-fit</i><br>
<a href=Chapter_22.ppt>[powerpoint]</a> <a href=Chapter_22.pdf>[pdf]</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 10 (due Monday April 11)]</b></a><br>
<!--<a href=HW/hw10-solutions.pdf><b>[Homework 10 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b>Week 13<br>April 11, 13</b></td>
     <td>Chapter 22 - <i>Two-way tables, conditional distributions, <u>chi-square test</u>,
     Chi-square requirements, goodness-of-fit</i><br>
<a href=Chapter_22.ppt>[powerpoint]</a> <a href=Chapter_22.pdf>[pdf]</a><br><br>
    Excel - <i>Building two-way tables, chi-square-score, p-value</i> (CHIDIST, CHIINV)<br>
Exercises: 
<a href=Excel/ch22/ex22-29.xls>22.29</a>,
<a href=Excel/ch22/ex22-34.xls>22.34</a><br>
Solutions:
<a href=Excel/ch22/ex22-29-solution.xls>22.29</a>,
<a href=Excel/ch22/ex22-34-solution.xls>22.34</a><br><br>
<!--
     <td>Chapter 23 - <i>Linear regression, assumptions, inference, correlation tests, prediction, residuals</i><br>
<a href=Chapter_23.ppt>[powerpoint]</a> <a href=Chapter_23.pdf>[pdf]</a><br><br>
     Excel - <i>Standard errors, prediction</i> (SLOPE, INTERCEPT, FORECAST, CORREl, DEVSQ)<br>
Exercises: <!-23.27, 23.31, ->
<a href=Excel/ch23/ex23-33.xls>23.33</a><br>
Solutions:
<a href=Excel/ch23/ex23-33-solution.xls>23.33</a><br>
-->
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 11 (due Monday April 18)]</b></a><br>
<!--<a href=HW/hw11-solutions.pdf><b>[Homework 11 solution key]</b></a>-->
</td>
</tr>
<tr>
<td><b><font color=red>Friday, April 15</font></b></td>
     <td><font color=red>Exam 2</font> - <i>Chapters 9-19</i>
<a href=Midterm2-S11.pdf>[Copy]</a> <br>
<!--<a href=Midterm2-practice-01-answers.pdf>[Answers]</a>-->
<!-- [Answers (Nov 6 afternoon)] -->
</td></tr>
<!--
<tr>
<td><b>Friday, November 26</b></td><td> THANKSGIVING</td>
</tr>
-->
<tr>
<td><b>Week 14<br>April 18, 20</b></td>
     <td>Chapter 24 - <i>Analysis of Variance idea, <u>ANOVA F-test and F-statistic</u>,
     ANOVA assumptions, confidence intervals</i><br>
<a href=Chapter_24.ppt>[powerpoint]</a> <a href=Chapter_24.pdf>[pdf]</a> <a href=f-table-1.pdf>[F table 1]</a> <a href=f-table-2.pdf>[F table 2]</a><br><br>
     Excel - <i>Standard errors, F-score</i> (DEVSQ, FDIST, FINV)<br>
Exercises: 
<a href=Excel/ch24/ta24-05.xls>24.33</a><br>
Solutions:
<a href=Excel/ch24/ta24-05-solution.xls>24.33</a><br><br>
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 12 (due Monday April 25)]</b></a>
<!--<a href=HW/hw12-solutions.pdf><b>[Homework 12 solution key]</b></a>-->
<br>
</tr>
<tr>
<td><b>Friday, April 22</b></td>
     <td>NO CLASS</td>
</tr>
<tr>
<td><b>Week 16<br>April 25, 27</b></td>
     <td>Chapter 25 - <i><u>Parametric vs. non-parametric tests, sign test,
     Ranking, two-sample non-parametric Wilkoxon test</u></i><br>
<a href=bps5e_chapter25.pdf>[Book Chapter]</a>
<a href=Chapter_25.ppt>[powerpoint]</a> <a href=Chapter_25.pdf>[pdf]</a><br><br>
     Excel - <i>Ranking, z-score, p-value</i> (RANK)<br>
Exercises:
<a href=Excel/ch25/ex25-45.xls>25.45</a>,
<a href=Excel/ch25/ta25-01.xls>25.51</a><br>
Solutions:
<a href=Excel/ch25/ex25-45-solution.xls>25.45</a>,
<a href=Excel/ch25/ta25-01-solution.xls>25.51</a><br><br>
<!--Chapters 1-25 - <i>The big picture</i><br><br>-->
<a href="http://webwork2.math.utah.edu/webwork2/math1070spring2011-3/"><b>[Homework 13 (due Monday May 2)]</b></a><br>
<!--<a href=HW/hw13-solutions.pdf><b>[Homework 13 solution key]</b></a>-->
</td>
     <!--<td>Chapters 1-25 - <i>The big picture</i></td>-->
</tr>
<tr>
<td><b><font color=red>Thursday May 5<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1pm-3pm</font></b></td>
     <td><font color=red>Final Exam</font> - Chapters 1-25</i><br>
<!--<a href=Part3-practice-01.pdf>[Practice for material after midterm 2]</a> 
<a href=Part3-practice-01-answers.pdf>[Answers]</a> -->
<a href=Final-S11-takehome.pdf><font color=red>[Take-home] (Due Thursday May 5)</font></a>
</td></tr>
</colgroup>
</colgroup>
</table>

<!-- One extra week can be cut out -->