Канал: Doug MacDormand

Stepwise Regression Using Excel

Stepwise Regression Using Excel

Check-all-that-apply Questions

Check-all-that-apply Questions

Test of Independence using Test of Independence-Template.xlsx

Test of Independence using Test of Independence-Template.xlsx

Correlation and SLR using the Template file

Correlation and SLR using the Template file

Two-Sample Tests of Means using Excel

Two-Sample Tests of Means using Excel

Two-Sample Test of Proportions using Excel

Two-Sample Test of Proportions using Excel

Friedman's Test using ANOVA Template File

Friedman's Test using ANOVA Template File

Kruskal-Wallis Using ANOVA Template File

Kruskal-Wallis Using ANOVA Template File

ANOVA using Excel's Analysis Toolpak and the ANOVA-Template.xlsx File

ANOVA using Excel's Analysis Toolpak and the ANOVA-Template.xlsx File

Data Cleaning - Part 5 - Special Question Types

Data Cleaning - Part 5 - Special Question Types

Data Cleaning - Part 4 - Errors and Issues 2

Data Cleaning - Part 4 - Errors and Issues 2

Data Cleaning - Part 3 - Errors and Issues 1

Data Cleaning - Part 3 - Errors and Issues 1

Data Cleaning - Part 2 - Useful Tools

Data Cleaning - Part 2 - Useful Tools

Data Cleaning - Part 1 - Setup

Data Cleaning - Part 1 - Setup

BUS 307 T10 - T14 (W21)

BUS 307 T10 - T14 (W21)

BUS 307 T4 - T10 (W21)

BUS 307 T4 - T10 (W21)

BUS 307 T1 - T4 (W21)

BUS 307 T1 - T4 (W21)

BUS 307 A10 - A12 (W21)

BUS 307 A10 - A12 (W21)

BUs 307 A18 - A33 (W21)

BUs 307 A18 - A33 (W21)

BUS 307 A13 - A17 (W21)

BUS 307 A13 - A17 (W21)

BUS 307 A8 - A9 (W21)

BUS 307 A8 - A9 (W21)

BUS 307 A7 - A8 (W21)

BUS 307 A7 - A8 (W21)

BUS 307 A4 - A6 (W21)

BUS 307 A4 - A6 (W21)

BUS 307 A1 - A3 (W21)

BUS 307 A1 - A3 (W21)

BUS 307 I8 - I17 (W21)

BUS 307 I8 - I17 (W21)

BUS 307 I1 - I7 (W21)

BUS 307 I1 - I7 (W21)

BUS 307 V7 - V12 (W21)

BUS 307 V7 - V12 (W21)

BUS 307 V4 - V7 (W21)

BUS 307 V4 - V7 (W21)

BUS 307 V1 - V3 (W21)

BUS 307 V1 - V3 (W21)

BUS 307 D17 - D30 (W21)

BUS 307 D17 - D30 (W21)

BUS 307 D13 - D16 (W21)

BUS 307 D13 - D16 (W21)

BUS 307 D12 (W21)

BUS 307 D12 (W21)

BUS 307 D6 - D11 (W21)

BUS 307 D6 - D11 (W21)

BUS 307 D5 (Response Bias) (W21)

BUS 307 D5 (Response Bias) (W21)

BUS 307 D5 (Instrument Bias) (W21)

BUS 307 D5 (Instrument Bias) (W21)

BUS 307 D3 - D5 (W21)

BUS 307 D3 - D5 (W21)

BUS 307 D1-D3 (W21)

BUS 307 D1-D3 (W21)

BUS 306 R4 - R11 (F20)

BUS 306 R4 - R11 (F20)

BUS 306 R1 - R3 (F20)

BUS 306 R1 - R3 (F20)

Excel for Hypothesis Tests

Excel for Hypothesis Tests

Bus 306 H13 - H17 (F20)

Bus 306 H13 - H17 (F20)

Bus 306 H10 - H12 (F20)

Bus 306 H10 - H12 (F20)

Bus 306 H6 - H9 (F20)

Bus 306 H6 - H9 (F20)

Bus 306 H4 - H5 (F20)

Bus 306 H4 - H5 (F20)

BUS 306 H1 - H4 (F20)

BUS 306 H1 - H4 (F20)

T Distribution and Confidence Interval Functions in Excel

T Distribution and Confidence Interval Functions in Excel

Normal Distribution Functions in Excel

Normal Distribution Functions in Excel

BUS 306 E27 - E33 (F20)

BUS 306 E27 - E33 (F20)

BUS 306 E24 - E26 (F20)

BUS 306 E24 - E26 (F20)

BUS 306 E20 - E23 (F20)

BUS 306 E20 - E23 (F20)

BUS 306 E15 - E20 (F20)

BUS 306 E15 - E20 (F20)

BUS 306 E10 - E14 (F20)

BUS 306 E10 - E14 (F20)

BUS 306 E8 - E9 (F20)

BUS 306 E8 - E9 (F20)

BUS 306 E6 - E8 (F20)

BUS 306 E6 - E8 (F20)

BUS 306 E1 - E6 (F20)

BUS 306 E1 - E6 (F20)

BUS 306 N13 - N22 (F20)

BUS 306 N13 - N22 (F20)

BUS 306 N11 - N12 (F20)

BUS 306 N11 - N12 (F20)

BUS 306 N10 - N11 (F20)

BUS 306 N10 - N11 (F20)

BUS 306 N4 - N9 (F20)

BUS 306 N4 - N9 (F20)

BUS 306 N1 - N4 (F20)

BUS 306 N1 - N4 (F20)

BUS 306 B16 - B18 (F20)

BUS 306 B16 - B18 (F20)

BUS 306 B14- B15 (F20)

BUS 306 B14- B15 (F20)

BUS 306 B12 - B13 (F20)

BUS 306 B12 - B13 (F20)

BUS 306 B8 - B11 (F20)

BUS 306 B8 - B11 (F20)

BUS 306 B4- B7 (F20)

BUS 306 B4- B7 (F20)

BUS 306 B1- B3 (F20)

BUS 306 B1- B3 (F20)

Binomial Functions in Excel

Binomial Functions in Excel

Simple Stats Functions and Descriptive Stats Tool

Simple Stats Functions and Descriptive Stats Tool

BUS 306 P18 - P32 (F20)

BUS 306 P18 - P32 (F20)

BUS 306 P16- P17 (F20)

BUS 306 P16- P17 (F20)

BUS 306 P14- P15 (F20)

BUS 306 P14- P15 (F20)

BUS 306 P6- P13 (F20)

BUS 306 P6- P13 (F20)

BUS 306 P1- P5 (F20)

BUS 306 P1- P5 (F20)

BUS 306 C11-C14 (F20)

BUS 306 C11-C14 (F20)

BUS 306 C27-C36 (F20)

BUS 306 C27-C36 (F20)

BUS 306 C26-C27 (F20)

BUS 306 C26-C27 (F20)

BUS 306 C25-C26 (F20)

BUS 306 C25-C26 (F20)

BUS 306 C19-C24 (F20)

BUS 306 C19-C24 (F20)

BUS 306 C15-C18 (F20)

BUS 306 C15-C18 (F20)

BUS 306 C9-C11 (F20)

BUS 306 C9-C11 (F20)

BUS 306 C5-C8 (F20)

BUS 306 C5-C8 (F20)

BUS 306 C1-C4 (F20)

BUS 306 C1-C4 (F20)

BUS 306 G21-G44 (F20)

BUS 306 G21-G44 (F20)

BUS 306 G15-G20 (F20)

BUS 306 G15-G20 (F20)

BUS 306 - G9-G13 (F20)

BUS 306 - G9-G13 (F20)

BUS 306 - G5-G8 (F20)

BUS 306 - G5-G8 (F20)

BUS 306 - G3-G4 (F20)

BUS 306 - G3-G4 (F20)

BUS 306 - G1-G2 (F20)

BUS 306 - G1-G2 (F20)

BUS 306 - I7 to I9 (F20)

BUS 306 - I7 to I9 (F20)

BUS 306 - I1 to I6 (F20)

BUS 306 - I1 to I6 (F20)

Dummy Variables Using Excel

Dummy Variables Using Excel

UNIT M - Multiple Linear Regression - M18 to M21

UNIT M - Multiple Linear Regression - M18 to M21

Unit M - Multiple Linear Regression - M14 to M17

Unit M - Multiple Linear Regression - M14 to M17

Unit M - Multiple Linear Regression - M10 to M13

Unit M - Multiple Linear Regression - M10 to M13

Unit M - Multiple Linear Regression - M7 to M9

Unit M - Multiple Linear Regression - M7 to M9

Unit M - Multiple Linear Regression - M1 to M7

Unit M - Multiple Linear Regression - M1 to M7

Unit S - Simple Linear Regression - S23 to S24

Unit S - Simple Linear Regression - S23 to S24

Unit S - Simple Linear Regression - S19 to S22

Unit S - Simple Linear Regression - S19 to S22

Unit S - Simple Linear Regression - S15 to S18

Unit S - Simple Linear Regression - S15 to S18

Unit S - Simple Linear Regression - S11 to S14

Unit S - Simple Linear Regression - S11 to S14

Unit S - Simple Linear Regression - S8 to S10

Unit S - Simple Linear Regression - S8 to S10

Unit S - Simple Linear Regression - S5 to S7

Unit S - Simple Linear Regression - S5 to S7

Simple Linear Regression Using Excel to Eliminate Outliers

Simple Linear Regression Using Excel to Eliminate Outliers

BUS 307 Unit S Simple Linear Regression S1 to S4

BUS 307 Unit S Simple Linear Regression S1 to S4

Regression Using Excel Analysis

Regression Using Excel Analysis

Correlation Using Excel

Correlation Using Excel

BUS 307 Unit C Correlation C8 to C9

BUS 307 Unit C Correlation C8 to C9

BUS 307 Unit C Correlation C7

BUS 307 Unit C Correlation C7

BUS 307 Unit C Correlation C5 to C6

BUS 307 Unit C Correlation C5 to C6

BUS 307 Unit C Correlation Pages C1 C4

BUS 307 Unit C Correlation Pages C1 C4

Goal Seek in Excel

Goal Seek in Excel

Random Number Generation

Random Number Generation

Test of Independence

Test of Independence

Creating Pivot Tables

Creating Pivot Tables

Normality and the COUNTIFS Function

Normality and the COUNTIFS Function

Stem and Leaf Graphs

Stem and Leaf Graphs

Median of Grouped Data

Median of Grouped Data

Making Graphs

Making Graphs

Getting Started in Excel

Getting Started in Excel

Histogram Tool

Histogram Tool

Cell Addressing

Cell Addressing

Descriptive Stats Tool

Descriptive Stats Tool