DOC PREVIEW
UIUC ECON 203 - Excel Functions

This preview shows page 1 out of 2 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

ECON 203 1st Edition Lecture 11Outline of Last LectureI. Difference in Proportion Tests1. FactsII. Case 11. Hypothesis Testing 4 Step SolutionA. Identify HypothesisB. Calculate Test StatisticC. Critical/P-ValueD. DecisionIII. Case 21. Hypothesis Testing 4 Step SolutionA. Identify HypothesisB. Calculate Test StatisticC. Critical/P-ValueD. DecisionOutline of Current LectureI. Excel1. TINV()2. CHIDIST()A. How Can You Tell?3. TDIST()4. NORMSDIST() and NORMSINV()A. How Can You Tell?Current LectureI. Excel1. TINV()- Will never give a negative critical value- Gives a critical value for a given probability and degree of freedom- Assumes a two tailed testThese notes represent a detailed interpretation of the professor’s lecture. GradeBuddy is best used as a supplement to your own notes, not as a substitute.- For a “t” test2. CHIDIST()- P-value from the right of the test statistic for a chi-squared problem- For X²A. How Can You Tell?- You know it’s a Chi-squared problem if the sentence says that there is a “variance” or “risk”3. TDIST()- Absolute value of the test statistic- Specify number of tails- Specify Degrees of Freedom- For a “t” test4. NORMSDIST() and NORMSINV ()- Calculates probability or critical value from the lef- Since they are the p function that uses the “Z” chart, which is NORM- For a “Z” or “u” problemA. How Can You Tell?- You can see proportions because they simply give the wins vs. losses. No data in an excel spread sheet, that will be all you need to find “p” and


View Full Document
Download Excel Functions
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Excel Functions and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Excel Functions 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?