1 / 37

Did you know: Traffic delay information is calculated using Bluetooth device information

Did you know: Traffic delay information is calculated using Bluetooth device information. Exam Procedures. Students should plan to arrive 15 minutes early Students MUST present a student ID to be admitted to the exam Students should plan to leave 15 minutes late

oprah-spence
Download Presentation

Did you know: Traffic delay information is calculated using Bluetooth device information

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Did you know:Traffic delay information is calculated using Bluetooth device information

  2. Exam Procedures • Students should plan to arrive 15 minutes early • Students MUST present a student ID to be admitted to the exam • Students should plan to leave 15 minutes late • Student will have 1 hour to complete the exam

  3. Exam Procedures – cont’d • Students may review printed instructions 10 minutes before the exam begins • Students begin the exam when instructed to • Warnings will be given when there are 15 minutes left, and 5 minutes left

  4. Exam Procedures – Cont’d • At the end of the exam, save and submit, but do not close it until you verify with the instructor (minimize it) • Hats turned backwards • No talking. Period. If I see you whispering anything to your neighbor, I will assume you are either asking them for help, or giving it to them – there’s an excellent chance you will be thrown out.

  5. Read & Understand • ABSOLUTELY NO ELECTRONIC DEVICES ON OR OUT DURING THE EXAM. IF ANYTHING BEEPS, BUZZES, RINGS, OR GIVES ME THE SLIGHTEST REASON TO THINK YOU’RE CHEATING I WILL NOT HESITATE TO THROW YOU OUT

  6. Friendly Reminders • I can see your computers, and the windows that are open, at all times from my computer. • Work the Exam Review Projects! They are great tools!

  7. Exam Dates • Section 8 (MW 11:30am) • Monday, September 29th (Allowed in the room at 11:20am) • Section 10 (MW 12:30pm) • Wednesday, October 1st (Allowed in the room at 12:20pm) **On the day you do not have an exam, you have a shortened class!  (About a half hour)

  8. Day 11:Excel Chapter 7 Cody Cutright CS 101 September 22nd, 2014

  9. Math and Statistics • Do not let the words math and statistics scare you, Excel will do all of the work. • You rely on statistics everyday to make routine decisions.

  10. Math and Statistical Function Categories • We’ve previously seen the SUM, AVERAGE, and COUNT functions. • Now we introduce SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS, and COUNTIFS • The functions in these categories rely on a conditional statement (An IF statement) • True returns one result, false the other

  11. SUMIF • Calculates the total of a range of values when a specified condition is met. • Used in place of SUM when you only want to calculate totals for certain data.

  12. SUMIF – Cont’d Form: =SUMIF(Range,Criteria,Sum_Range) Range: The range of cells you want to evaluate to test your criteria. Criteria: The condition specified that decides whether or not Excel sums values. Sum_Range: Designates the cell values to be added if the criteria is met

  13. averageIF • Calculates the average of values in a range when a specified condition is met. • Used in place of AVERAGE when you only want to average certain data.

  14. AVERAGEIF – cont’d Form: =AVERAGEIF(Range,Criteria,Average_Range) Range: The range of cells you want to evaluate to test your criteria. Criteria: The condition specified that decides whether or not Excel averages values. Sum_Range: Designates the cell values to be averaged if the criteria is met

  15. countIF Form: =COUNTIF(Range,Criteria) Range: The range of cells you want to evaluate to test your criteria. Criteria: The condition specified that decides whether or not Excel counts values.

  16. SumIF example

  17. (SUM/Count/AVERAGE)IFS • These functions are structured backwards from the previous arguments. • These can be used to SUM/COUNT/AVERAGE

  18. SUMIFs • Calculates a total of a range of values when multiple conditions are met. • Form: =SUMIFS(sum_range,criteria1_range1,criteria1,criteria2_range2,criteria2,…)

  19. SUMIFs - cont’d • Sum_Range: Designates the cells containing values to add if the condition is met • Criteria_Range1: Specifies the first range of cells you want to evaluate to see if they meet a particular condition. • Criteria1: Specifies the condition for the criteria_range1 argument.

  20. AVERAGEIFS/COUNTIFS • Work similar to SUMIFS • Example Link:

  21. Statistical Functions RANK.EQ: Identifies the rank of a value, omitting the next rank when tie values exist. RANK.AVG: Identifies the rank of a value, providing an average ranking for identical values. Same form as the RANK function: =RANK.(EQ/AVG)(number,ref,order)

  22. Logical and Lookup Functions Logical functions enable you to test conditions to determine if they are true or false. We have dealt with logical functions before, we will now turn to nested logical functions.

  23. Nested Functions Excel allows functions to have embedded (nested) functions. Sidenote: Excel permits up to 64 IF statements in one formula.

  24. Nested IF within an IF • If a representative sells up to $1,000, the rep earns a 5% commission on the sales. • If a representative sells over $1,000 and up to $5,000, the rep earns a 7.25% commission on the sales. • If a representative sells over $5,000, the rep earns a 10% commission on the sales.

  25. Nested IF within an IF

  26. Don’t be intimidated, use a flowchart! Insert cell values Value_if_true E2*B$3 Sales * 5% IFE2 <= A$3 IF sales<= $1,000 Value_if_true E2*B$4 Sales * 7.25% IF E2 <= A$4 IF sales<= $5,000 Value_if_false E2*B$5 Sales * 10% Value_if_false

  27. Final Formula =IF(E2<=A$3,E2*B$3,IF(E2<=A$4,E2*B$4,E2*B$5) Sales * 7.5% Sales <= 1000 Sales * 5% Otherwise (>5000) Sales * 10%) More than 1000, <= 5000

  28. How Many Logical Tests? In the previous example, we had three possible outcomes, and two logical tests. In general, for any N possible outcomes, you use N-1 logical tests.

  29. AND Function The AND function accepts two or more logical tests and displays TRUE if all conditions are true, or FALSE if any condition is not satisfied. Form: =AND(logical1,logical2) **Up to 255 conditions

  30. AND in Action The function only displays true when both conditions are met.

  31. OR Function The OR function also accepts two or more conditions and returns TRUE if any of the conditions are met, and only returns FALSE if all conditions are false. Form: =OR(logical1,logical2) *Also up to 255 logical tests

  32. OR in Action Displays TRUE if one of the conditions is satisfied.

  33. NOT Function The NOT function contains only one logical argument and returns TRUE if the argument is false and FALSE if the argument is true. Form: =NOT(logical)

  34. Data Analysis ToolPak The Analysis ToolPakis an add-in program that contains tools for performing complex statistical analysis.

  35. Enable the ToolPak • File Tab -> Options • Select Add-Ins on the left side • Make sure Excel Add-Ins is selected, then click Go • Check the Analysis ToolPak checkbox, then OK

  36. Use a tool from the ToolPak The Analysis ToolPakis an add-in program that contains tools for performing complex statistical analysis.

More Related