English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 184 Lessons (25h 12m) | 4.13 GB
Learn Statistics in Excel and RStudio. Learn statistics from ground zero then utilize Excel and RStudio for statistical calculations and data visualization.
What you’ll learn
- Create mathematical regression models that can be used in a predictive manner.
- Perform one-sample and two-sample statistical hypothesis tests.
- Perform a variety of statistical tests, create regression models, and analyze data using Microsoft Excel as well as R (RStudio).
Skills you’ll gain
- Statistics
- Data Analytics
- Microsoft Excel
- Data Analysis
- RStudio
A comprehensive understanding of statistics and data analysis is paramount for the fields of data science, data analytics, and machine learning. In the first course of this specialization, you will learn traditional and applied statistics (descriptive statistics, probability, and discrete and continuous probability distributions) from ground zero (i.e., beginner level).
The second course is all about inferential statistics and making decisions (sampling distributions, one- and two-sample hypothesis tests, analysis of variance) and creating predictive mathematical models (linear and nonlinear regression). Throughout both of the first two courses, you will learn how to visualize data and solve various statistical problems using Microsoft Excel.
In the final course of the specialization, you will use the statistical computing software R (using RStudio) for statistical hypothesis tests, data visualization, and analysis of variance (ANOVA).
Applied Learning Project
Parts 1 and 2 of the specialization have “guided” workshop quizzes during each week of the course for learners to work along with the instructor through relevant and exciting statistics related problems. In Part 3 of the course, assignments are in-application (i.e., in the programming language R) and are submitted online.
Table of Contents
statistics-and-data-analysis-with-excel-part-1
welcome
introduction-and-general-course-information
1 welcome-to-the-course
2 how-the-course-works
3 the-importance-of-a-course-certificate-and-the-future-of-higher-education_instructions
4 auditing-the-course-vs-purchasing-a-course-certificate_instructions
5 do-your-excel-skills-need-work_instructions
6 what-version-of-excel-do-you-need-for-this-course_instructions
7 is-it-data-are-or-data-is_instructions
statistics-and-data-analysis-an-introduction
8 introduction-to-statistics
descriptive-statistics-and-graphical-representation-of-data
week-2-cheat-sheet
9 week-2-cheat-sheet_instructions
descriptive-statistics
10 difference-between-population-and-sample
11 what-is-the-summation-symbol
12 descriptive-statistics
13 quartiles-and-percentiles
graphical-presentation-of-data
14 univariate-vs-bivariate-data
15 categorical-vs-numerical-data
16 histograms
17 scatter-plots-in-excel-part-1
18 scatter-plots-in-excel-part-2
19 column-and-pie-charts-in-excel
20 time-series-plots
21 box-plots
preparing-data-robust-estimators-and-removing-outliers
22 cleaning-data-in-excel
23 data-transformations
24 robust-estimators
25 removing-outliers
reinforce-your-learning
26 guided-workshop-2_instructions
27 guided-workshop-2-creating-a-histogram-in-excel
probability
week-3-cheat-sheet
28 week-3-cheat-sheet_instructions
sample-spaces-and-counting-techniques
29 introduction-to-probability-part-1
30 introduction-to-probability-part-2
31 sample-spaces-and-events
32 permutations-and-combinations
33 how-to-use-the-permut-and-combin-functions-in-excel
conditional-probability
34 probability-rules
35 conditional-probability
36 multiplication-rule
37 total-probability-rule
38 bayes-theorem
reinforce-your-learning
39 guided-workshop-3_instructions
40 guided-workshop-3-bayes-theorem-and-diagnostic-testing
discrete-probability-distributions
week-4-cheat-sheet
41 week-4-cheat-sheet_instructions
introduction
42 introduction-to-discrete-probability-distributions
43 probability-distributions
44 excel-functions-for-discrete-distributions_instructions
bernoulli-processes
45 the-binomial-distribution
46 the-geometric-distribution
47 the-negative-binomial-distribution
48 excels-negbinom-dist-function
sampling-without-replacement
49 the-hypergeometric-distribution
50 the-multinomial-distribution
poisson-process
51 the-poisson-distribution
joint-and-conditional-probability-distributions
52 joint-and-marginal-probability-distributions
53 conditional-probability-distributions
closing-the-loop
54 closing-the-loop
reinforce-your-learning
55 guided-workshop-4_instructions
56 guided-workshop-4-modeling-traffic-data
continuous-probability-distributions
week-5-cheat-sheet
57 week-5-cheat-sheet_instructions
introduction-to-continuous-distributions
58 introduction-to-continuous-distributions
59 continuous-variables-and-distributions
60 the-uniform-distribution
61 excel-functions-for-continuous-distributions_instructions
62 the-normal-distribution
standardizing
63 standardizing-and-z-values-part-1
64 standardizing-and-z-values-part-2
65 percentage-points-of-the-standard-normal-distribution-table_instructions
66 inverse-normal-distribution-calculations
other-continuous-distributions
67 exponential-distribution
68 other-continuous-distributions
69 example-beta-pert-distribution
probability-plots
70 probability-plots
71 how-to-use-the-probability-plot-xlsx-file
closing-the-loop
72 closing-the-loop
reinforce-your-learning
73 guided-workshop-5_instructions
74 guided-workshop-5-fitting-data-to-the-gamma-distribution
statistics-and-data-analysis-with-excel-part-2
introduction-and-review
welcome
75 welcome-to-the-course
76 how-the-course-works
course-basics
77 the-importance-of-a-course-certificate-and-the-future-of-higher-education_instructions
78 auditing-the-course-vs-purchasing-a-course-certificate_instructions
79 what-version-of-excel-do-you-need-for-this-course_instructions
optional-review-your-standardizing-skills
80 do-you-need-to-review_instructions
81 standardizing-and-z-values-part-1
82 standardizing-and-z-values-part-2
83 percentage-points-of-the-standard-normal-distribution-table_instructions
84 inverse-normal-distribution-calculations
sampling-distributions-and-the-central-limit-theorem
week-2-cheat-sheet
85 week-2-cheat-sheet_instructions
introduction-to-inferential-statistics
86 introduction-to-inferential-statistics
87 sampling-distribution-vs-population-distribution
88 the-central-limit-theorem
89 variance-known-or-unknown
90 confidence-interval-on-the-mean-variance-known
the-t-distribution
91 the-t-distribution
92 percentage-points-of-the-t-distribution-table_instructions
93 excel-functions-for-the-standard-normal-and-t-distributions_instructions
94 confidence-interval-on-the-mean-variance-unknown
95 using-the-confidence-norm-and-confidence-t-functions-in-excel
96 prediction-interval-on-a-future-observation
the-chi-squared-distribution
97 the-chi-squared-distribution-and-confidence-intervals-on-the-variance
98 percentage-points-of-the-chi-squared-distribution-table_instructions
99 excel-functions-for-the-chi-squared-distribution_instructions
reinforce-your-learning
100 guided-workshop-2_instructions
101 guided-workshop-2-confidence-interval-calculator-for-small-data-sets
one-sample-hypothesis-tests
week-3-cheat-sheet
102 week-3-cheat-sheet_instructions
hypothesis-tests-on-the-mean
103 introduction-to-hypothesis-testing-part-1
104 introduction-to-hypothesis-testing-part-2
105 hypothesis-tests-on-the-mean-using-confidence-intervals
106 the-test-statistic-approach-to-hypothesis-testing
107 using-p-values-for-hypothesis-testing-on-the-mean-part-1
108 using-p-values-for-hypothesis-testing-on-the-mean-part-2
type-ii-error-and-power
109 type-i-and-type-ii-errors
110 example-type-ii-error
111 power-of-the-test
112 choice-of-sample-size-and-oc-curves
113 choice-of-sample-size-variance-unknown
hypothesis-tests-on-the-variance-and-binomial-proportions
114 hypothesis-tests-on-the-variance
115 hypothesis-tests-on-a-binomial-proportion
reinforce-your-learning
116 guided-workshop-3_instructions
117 guided-workshop-3-real-time-power-calculator
two-sample-hypothesis-tests
week-4-cheat-sheet
118 week-4-cheat-sheet_instructions
comparison-of-means
119 comparison-of-means-flowchart_instructions
120 comparison-of-means-variance-known-part-1
121 comparison-of-means-variance-known-part-2
122 comparison-of-means-variance-unknown-part-1
123 comparison-of-means-variance-unknown-part-2
124 paired-t-tests
125 excel-functions-for-the-f-distribution_instructions
the-f-distribution
126 the-f-distribution-and-comparison-of-variances
127 percentage-points-of-the-f-distribution-table_instructions
comparison-of-proportions
128 comparison-of-proportions
reinforce-your-learning
129 guided-workshop-4_instructions
130 guided-workshop-4-two-sample-t-test-calculator
linear-regression
week-5-cheat-sheet
131 week-5-cheat-sheet_instructions
introduction-to-regression
132 linear-regression-part-1-simple-linear-models-straight-line
133 linear-regression-part-2-general-linear-models
134 linear-regression-part-3-multilinear-regression
simple-linear-regression
135 simple-linear-regression-using-least-squares-estimators
136 hypothesis-tests-for-simple-linear-regression
137 confidence-intervals-on-slope-and-intercept
138 examples-confidence-interval-on-the-slope
139 confidence-interval-on-the-mean-response
140 coefficient-of-determination-and-adjusted-r-squared
reinforce-your-learning
141 guided-workshop-5_instructions
142 guided-workshop-5-prediction-interval-for-a-future-observation
multilinear-regression
week-6-cheat-sheet
143 week-6-cheat-sheet_instructions
multiple-linear-regression
144 matrix-approach-to-multiple-linear-regression
145 statistical-properties-of-least-squares-estimators
146 hypothesis-tests-in-multiple-linear-regression-part-1
147 hypothesis-tests-in-multiple-linear-regression-part-2
148 confidence-intervals-in-multiple-linear-regression
149 introduction-to-nonlinear-regression-logistic-regression
reinforce-your-learning
150 guided-workshop-6_instructions
151 guided-workshop-6-real-time-multilinear-regression-calculator
anova
week-7-cheat-sheet
152 week-7-cheat-sheet_instructions
analysis-of-variance-anova
153 single-factor-anova-introduction-and-terminology
154 single-factor-anova-partitioning-the-sum-of-squares-and-creating-the-anova-table
155 single-factor-anova-comparison-of-means
reinforce-your-learning
156 guided-workshop-7_instructions
157 guided-workshop-7-two-way-analysis-of-variance
statistics-and-data-analysis-with-r
welcome-and-introduction-to-the-r-programming-language
course-introduction
158 welcome-to-the-course
159 how-the-course-works
160 the-importance-of-a-course-certificate-and-the-future-of-higher-education_instructions
161 auditing-the-course-vs-purchasing-a-course-certificate_instructions
introduction-to-rstudio-and-working-with-data
162 week-1-starter-files-and-cheat-sheet_instructions
163 introduction-to-r-and-rstudio
164 installation-links_instructions
165 basic-calculations-in-r
166 using-script-files
167 vectors-and-matrices-part-1
168 vectors-and-matrices-part-2
169 how-to-install-and-load-packages
170 data-frames-and-tibbles
171 additional-data-frame-examples
172 importing-data-into-rstudio
173 how-to-use-built-in-functions
174 user-defined-functions
check-your-understanding
175 how-programming-assignments-work
descriptive-statistics-and-graphical-presentation-of-data
descriptive-statistics
176 descriptive-statistics-part-1
177 descriptive-statistics-part-2
178 conditional-statistics
graphical-presentation-of-data
179 scatter-plots-part-1
180 scatter-plots-part-2
181 histograms
182 column-and-pie-plots
183 box-plots
184 probability-plots-and-the-ad-statistic
counting-techniques-and-probability-distribution-functions
counting-techniques
185 permutations-and-combinations
discrete-distributions
186 the-binomial-distribution
187 the-geometric-distribution
188 the-negative-binomial-distribution
189 the-hypergeometric-distribution
190 the-poisson-distribution
191 the-multinomial-distribution
continuous-distributions
192 the-uniform-distribution
193 the-normal-distribution
194 inverse-normal-distribution-calculations
195 standardizing-and-z-values
196 optional-review-variance-known-or-unknown
197 optional-review-sampling-distribution-vs-population-distribution
198 the-t-distribution
199 the-chi-squared-distribution
200 the-f-distribution
one-sample-hypothesis-testing
tests-on-the-mean
201 confidence-interval-on-the-mean-variance-known
202 confidence-interval-on-the-mean-variance-unknown
203 prediction-interval-on-a-future-observation
204 hypothesis-tests-on-the-mean-variance-known
205 hypothesis-tests-on-the-mean-variance-unknown
type-ii-error-beta-power-and-sample-size
206 optional-review-type-i-and-type-ii-errors
207 optional-review-power-of-the-test
208 type-ii-error-and-power-of-the-test
209 choice-of-sample-size
tests-on-the-variance
210 confidence-interval-on-the-variance
211 hypothesis-tests-on-the-variance
tests-on-a-binomial-proportion
212 hypothesis-tests-on-a-binomial-proportion
two-sample-hypothesis-tests
comparison-of-means-and-variances
213 comparison-of-means-variance-known-part-1
214 comparison-of-means-variance-known-part-2
215 comparison-of-variances-f-test-part-1
216 comparison-of-variances-f-test-part-2
217 comparison-of-means-variance-unknown
paired-tests
218 paired-t-tests
comparison-of-binomial-proportions
219 comparison-of-binomial-proportions
regression-and-anova
regression-residual-analysis-and-model-building
220 simple-linear-regression-part-1
221 simple-linear-regression-part-2
222 residual-analysis-part-1
223 residual-analysis-part-2
224 polynomial-regression
225 multilinear-regression
226 model-building-techniques-part-1
227 model-building-techniques-part-2
analysis-of-variance
228 analysis-of-variance
Resolve the captcha to access the links!