Descriptive Statistics using Excel
May 2011 / Dr Rensvold
Open the Excel spreadsheet labeled "Example Database." The first page is the Data Dictionary. The Variable Label is the "handle" used for computation. The Variable Name is longer and more descriptive. The Values column shows the numerical values associated with categorical variables. In the data dictionary, you can see that the only categorical (nominal) variable is SEX. The others are ratio variables (why?)

Click on the Data tab, which opens the window with the data.

We wish to obtain descriptive statistics for these data. The next step is to click on the Data tab at the top of the window.

The Data tab presents a number of data-related options. Click on the "Data Analysis" button. If you don't see this button, the data analysis package will have to be installed. See the "Background Information" for a tutorial on how to install it.

Select "Descriptive Statistics" as shown, then click OK. This brings up the Descriptive Statistics dialog, shown below.

The program needs to know where to find the data you want analyzed. Click the icon on the right-hand side of the Input Range window. This takes you back to the Data window.

In the data window, click and drag to highlight the cells containing the data you want to analyze. Be sure to include the top line, which includes the labels. Select the cells from A1 to D13. (Excel writes this "$A$1:$D$13,") to indicate that we're talking about the cell addresses and not the data in the cells, which may change from one iteration of the test to another.)

Click the icon shown above to go back to the Descriptive Statistics dialog.

The "Input Range" window, at the top of the dialog box, now contains the range of data cells. Before clicking OK, make sure:
•
•
•

the "Group By" Columns radio button is selected.
the "Labels in the First Row" box is checked.
the "Summary Statistics" box is checked.

...Sensitivity Analysis UsingExcel
2
The main goal of sensitivity analysis is to gain insight into which assumptions are critical, i.e., which assumptions affect choice. The process involves various ways of changing input values of the model to see the effect on the output value. In some decision situations you can use a single model to investigate several alternatives. In other cases, you may use a separate spreadsheet model for each alternative.
2.1 MANUAL...

...Using Microsoft Excel 2010
Advanced Skills
Using Microsoft Excel
Advanced Skills
Excel contains numerous tools that are intended to meet a wide range of
requirements. Some of the more specialised tools are useful to only
certain types of people while others have value for more general excel
users. These exercises will cover some of the advanced features that may
be useful for most...

...User Guide for Excel Modification
In this guide we are going to show you how to retrieve your e-mail in Web version of Outlook and change an excel spreadsheet. With your computer turn on, click on your web browser and type https://mail.lhup.edu/. You should have a dialog box pop up you need to click yes. A screen will open for you to enter your screen id and password. When Outlook opens on your right hand side should be a list of items you want to make sure...

...Financial Analysis usingExcel
Function
Information requirements for function
Dates
Prices and par values
Frequency, and related
Yields and interest/ discount rates Discount
Any amount paid at maturity ?
Frequency of payme nts pa
First coupon
Redemption amount
Investment amount
# of periods
Settlement
Par/coupon
Maturity
COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT...

...
Contents
Question 1 3
Question 2a 5
Question 2b 6
Question 2c 7
Question 3a 8
Question 3b 8
Question 3c 10
Question 3d 11
Question 4 12
Question 5 14
References 15
Question 1
The sampling method that Mr. Kwok is using is Stratified Random Sampling Method. In this case study, Mr Kwok collected a random sample of 1000 flights and proportions of three routes in the sample. He divides them into different sub-groups such as satisfaction,...

...route from my house to work? . . . And many more.
Some of these decisions can be made without thinking or by guesswork. Some can be solved by
reasoning or emotions. Some are a bit more diﬃcult and may need additional information.
People have been using mathematical tools to aid decision making for decades. During World
War II many techniques were developed to assists the military in decision making. These developments were so successful that after World War II many companies...

...Trajico, Maria Liticia D.
BSEd III-A2
REFLECTION
The first thing that puffs in my mind when I heard the word STATISTIC is that it was a very hard subject because it is another branch of mathematics that will make my head or brain bleed of thinking of how I will handle it. I have learned that statistic is a branch of mathematics concerned with the study of information that is expressed in numbers, for example information about the number of times...

...Organization of Terms
Experimental Design
Descriptive
Inferential
Population
Parameter
Sample
Random
Bias
Statistic
Types of
Variables
Graphs
Measurement scales
Nominal
Ordinal
Interval
Ratio
Qualitative
Quantitative
Independent
Dependent
Bar Graph
Histogram
Box plot
Scatterplot
Measures of
Center
Spread
Shape
Mean
Median
Mode
Range
Variance
Standard deviation
Skewness
Kurtosis
Tests of
Association
Inference
Correlation...

1764 Words |
6 Pages

Share this Document

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"NL","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":37021189,"categoryName":"Software Development","categoryParentId":"5","currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":3,"pageRange":"1-3","totalPages":3}},"access":"premium","title":"Statistics Using Excel","additionalIds":[17,83,3,7],"additional":["Literature","Computer Science\/Domains","Business \u0026 Economy","Education"],"loadedPages":{"html":[],"text":[1,2,3]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/Statistics-Using-Excel-1415328.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.8","language":"en_US"},"analytics":{"googleId":"UA-32718321-1"}}