[PDF] [PDF] Basic Data Analysis Using MS Excel - UConn 4-H

[PDF] Preview Excel Data Analysis Tutorial - Tutorialspoint

Data Analysis with Excel is a comprehensive tutorial that provides a good Copying Name using Formula Autocomplete Copying Formulas with Names

[PDF] Analyzing Data Using Excel

Excel can assist you in this analysis of data You can display of complex mathematical formulas You choose to use Excel to import the data into and analyze

[PDF] Basic Data Analysis Using MS Excel - UConn 4-H

Multiple ways to go about your analysis 1) Toolpak 2) Formulas 3) Manual entry Page 13 

[PDF] Introduction to Data Analysis Using an Excel - UMD Physics

formulas, the graph changes automatically Still another advantage of a spreadsheet is that it can easily handle the statistical analysis of data sets with hundreds, 

[PDF] Excel 2016 Data analysis - UQ Library - University of Queensland

Import data • Use statistical functions in Excel or a USB drive Statistical Function definitions can be found at: Microsoft Excel: Data Analysis Importing 

[PDF] MICROSOFT EXCEL STEP BY STEP GUIDE - ICT Lounge

Your model should adapt to this new number and re-calculate the updated times table answers Save the spreadsheet as Data Analysis – Task B Updated A1 cell  

[PDF] Basic Statistical Analysis in Excel

In the next cell, insert the formula =MEDIAN(e2:e1054) You should get the data below Which of these two figures should you use? The mean is higher because it 

[PDF] excel formulas in hindi pdf

[PDF] excel formulas pdf free download

[PDF] excel formulas with examples xls

[PDF] excel intermediate tutorial pdf

[PDF] excel interview questions for data analyst

[PDF] excel is fun power query

[PDF] excel macro for pdf

[PDF] excel macro interview questions

[PDF] excel macro tutorial pdf download

[PDF] excel macro tutorial pdf free download

[PDF] excel macros basics pdf

[PDF] excel macros basics tutorial pdf

[PDF] excel macros for beginners pdf

[PDF] excel macros learning pdf

[PDF] excel macros tutorial pdf

Basic Data Analysis Using MS Excel

Teresa McCoy

Assistant Director, University of Maryland Extension Evaluation & Assessment

First Things First: Toolpak

Click on the box, "Analysis Toolpak," and Then click on "OK" You will see the "Data Analysis" option appear on the right-hand side of your ribbon.

Overview

I. Data Management

II. Data Manipulation

III. Data Analysis

IV. Data Communication

Preface

Relax and just listen

Beginner pace Exposure to the Excel platform Exposure to T-Tests Tips & Tricks Support Materials

1) Sort

2) Filter Tip: Auto- or Flash-fill

Data Manipulation

Sort

Select the data in my spreadsheet.

Go to "Data" tab. Select "Sort." I'm going to sort by Column B (county) in alphabetical order.

Sort & Filter

Auto or Flash Fill: Can fill in the same value or formula or a sequence

Grab the handle at the bottom right corner. Hold and drag Thereisalsoa"Fill"op/onontheHomeMenuRibbonwhereyoucansetupmul/plefillop/ons.

III. Data Analysis

Caveat

Multiple ways to go about your analysis.

1) Toolpak 2) Formulas 3) Manual entry

Descriptive Stats Using Toolpak

N=149

Example: Typing in a Formula

Using Formulas from the Formula Tab

P-Valueshowsas.36

III. Data Analysis

Review Main Points

• T-test looks for significant difference between two sets of data.

• Eliminates our bias. • Science wants a 95% confidence level. • T-test returns the p-value (probability). • Want a p-value that is <.05 • Because that says the difference in the data

is NOT attributable to random chance.

Review Main Points

If the results are not attributable to chance,

Then our program intervention

worked.

Question

Is there a significant difference between girls and boys in the number of hours spent in 4-H activities each week? Open-ended; therefore a two-tailed t-test

Question

Do boys spend more time each week in 4-H activities than girls? Closed-ended; one direction; therefore a one-tailed t-test

Paired or Unpaired Data

Paired

Paired or Unpaired DataUnpaired

Let's go back to a question

Is there a significant difference between girls and boys in the number of hours spent in 4-H activities each week? Open-ended; therefore a two-tailed t-test

Two-tailed T-Test on Unpaired Data Using Formula Bar

T-Test Result of p=.36

Can we be confident that there is a significant difference between girls and boys in the number of hours spent in 4-H activities each week?

No

Two-tailed T-Test on Unpaired Data Using Toolpak

Remember,

• Look back at the video. • Don't be intimidated. • Ask for help.

I. Data Management

Data Entry Quality Tool = Data Validation

Data Validation

1) Select the cells that you want to include in the data validation.

2) Choose an empty space in

your spreadsheet and type in the answers you will accept.

3) Click on your data

validation option.

Thisistheareaonthesheetfordataentry.

Data Validation

4) The data validation dialog box will open.

5) In "Allow," choose the

drop-down box and choose "List."

6) You will then have to tell

Excel what list to use.

7) Go back to the area of the

sheet where you typed in the allowable entries and drag across those boxes.

Data Validation

• Users can only choose what you have listed. • This eliminates user error in data entry.quotesdbs_dbs7.pdfusesText_13