STAT C1000 / MATH 119 HOME

 

EXCEL TEMPLATES

EXCEL FOR MAC TUTORIALS (ADVANCED)

005: Arrays

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel005Arrays.xlsx

 

020: Frequency Tables

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel020FrequencyTables.xlsx

 

030: Line Charts

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel030LineCharts.xlsx

 

040: Histograms

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel040Histograms.xlsx

 

050: Center

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel050Center.xlsx

 

055: Center (Presidents’ Ages)

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel055CenterPresidentsAges.xlsx

 

070: Spread

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel070Spread.xlsx

 

080: Percentiles

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel080Percentiles.xlsx

 

090: Five-Number Summary

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel090FiveNumberSummary.xlsx

 

100: Boxplots

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel100Boxplots.xlsx

 

500: Scatterplots

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel500Scatterplots.xlsx

 

510: Correlation and Regression

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel510CorrelationRegression.xlsx

 

530: Calculations and Regression

OR https://www.kkuniyuk.com/StatisticsBook/v002/Excel530CalculationsRegression.xlsx

 

 

EXCEL FOR MAC (BASIC)

0a: Random Integers

OR https://www.kkuniyuk.com/StatisticsBook/v002/0aRandomIntegers.xlsx

 

0b: Measures of Center (Presidents Ages)

OR https://www.kkuniyuk.com/StatisticsBook/v002/0bMeasuresOfCenter.xlsx

 

0b2: Plug in Biden’s Age

OR https://www.kkuniyuk.com/StatisticsBook/v002/0b2MeasuresOfCenterPlugInBiden.xlsx

 

0c: SD, VAR, and Range

OR https://www.kkuniyuk.com/StatisticsBook/v002/0cSDvarRange.xlsx

 

0c2: Plug in Biden’s Age

OR https://www.kkuniyuk.com/StatisticsBook/v002/0c2MeasuresOfSpreadPlugInBiden.xlsx

 

1: Mean, Median, and SD

OR https://www.kkuniyuk.com/StatisticsBook/v002/1MeanMedianSD.xlsx

 

2: Random Numbers from Uniform Distributions

OR https://www.kkuniyuk.com/StatisticsBook/v002/2UniformRandomNumbers.xlsx

 

3: Random Numbers from Normal Distributions

OR https://www.kkuniyuk.com/StatisticsBook/v002/3NormalRandom.xlsx

 

4: Probabilities and Percentiles for Normal Distributions

OR https://www.kkuniyuk.com/StatisticsBook/v002/4NormalProbabilities.xlsx

 

5: Probabilities for Binomial Distributions

OR https://www.kkuniyuk.com/StatisticsBook/v002/5BinomialProbabilities.xlsx

 

5 (More): Probabilities for Binomial Distributions (Monty Hall)

OR https://www.kkuniyuk.com/StatisticsBook/v002/5MontyHall.xlsx

 

 

6: Critical Values

OR https://www.kkuniyuk.com/StatisticsBook/v002/6CriticalValuesZ.xlsx

 

7: 95% Confidence Interval for a Population Mean (z Distribution) (Lesson 28)

OR https://www.kkuniyuk.com/StatisticsBook/v002/7ConfidenceIntervalsZ95percent.xlsx

 

8: 99% Confidence Interval for a Population Mean (z Distribution) (Lesson 28)

OR https://www.kkuniyuk.com/StatisticsBook/v002/8ConfidenceIntervalsZ99percent.xlsx

 

9: Confidence Intervals for a Population Mean (t Distributions) (Lesson 29)

OR https://www.kkuniyuk.com/StatisticsBook/v002/9ConfidenceIntervalsT.xlsx

 

10: Confidence Intervals for p, a Population Probability or Proportion (z Distribution) (Lesson 30)

OR https://www.kkuniyuk.com/StatisticsBook/v002/10ConfidenceIntervalsP.xlsx

 

11: Confidence Intervals for a Population Variance or SD (Chi-Square Distributions) (Lesson 31)

OR https://www.kkuniyuk.com/StatisticsBook/v002/11ConfidenceIntervalsChiSquare.xlsx

 

12: Binomial Probabilities for Lesson 32 (Lesson 32: Hypothesis Testing; P-Values; Coins)

OR https://www.kkuniyuk.com/StatisticsBook/v002/12BinomialProbsForLesson32.xlsx

 

13: Chi-Square Test for Goodness-of-Fit (Lesson 40)

OR https://www.kkuniyuk.com/StatisticsBook/v002/13GoodnessOfFit.xlsx

 

14: Chi-Square Test for Independence (Lesson 41)

OR https://www.kkuniyuk.com/StatisticsBook/v002/14Independence.xlsx

 

15: Correlation and Regression (Lesson 43)

OR https://www.kkuniyuk.com/StatisticsBook/v002/15CorrelationRegression.xlsx

 

16: Summary of Critical Values and P-Values (GREAT SUMMARY!)

OR https://www.kkuniyuk.com/StatisticsBook/v002/16SummaryCriticalValuesPvalues.xlsx

 

 

STAT C1000 / MATH 119 HOME