This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: STAT 31 Practice Midterm 1 Spring 2004 INSTRUCTIONS: BOTH THE EXAM AND THE BUBBLE SHEET WILL BE COLLECTED. YOU MUST PRINT YOUR NAME AND SIGN THE HONOR PLEDGE ON THE BUBBLE SHEET. YOU MUST BUBBLE-IN YOUR NAME & YOUR STUDENT IDENTIFICATION NUMBER. EACH QUESTION HAS ONLY ONE CORRECT CHOICE (decimals may need rounding). USE "NUMBER 2" PENCIL ONLY - DO NOT USE INK - FILL BUBBLE COMPLETELY. NO NOTES OR REMARKS ARE ACCEPTED - DO NOT TEAR OR FOLD THE BUBBLE SHEET. A GRADE OF ZERO WILL BE ASSIGNED FOR THE ENTIRE EXAM IF THE BUBBLE SHEET IS NOT FILLED OUT ACCORDING TO THE ABOVE INSTRUCTIONS. QUESTIONS ARE WORTH ONE POINT EACH. This practice exam covers Chapter 1 and Sections 2.1 and 2.2. All the questions are supposed to give you some idea about the form of the exam and the types of questions in the exam. By no means you should consider these as a complete set of questions that might appear on the exam. Suggestion: Look at the questions, work on them first WITHOUT using the answer keys. Look through the textbook to help you solve those questions you can not solve. Final, look at the answer keys to help you solve those still-unsolved questions. The final final step is to ask for help from fellow students or the instructor. Good Luck! 1. In an Excel spreadsheet, the entries in cells A1:A3 are 6, 4, 5 while the entries in cells B1:B3 are 1, 2, 4. If I type the formula: =COUNT(B$1:B$4) into cell A5, the result in cell A5 equals A) 7 B) 15 C) 3 D) 4 Page 1 2. One Excel spreadsheet has data in columns A, B, C and rows 1, 2, 3. The numbers in cells A1:A3 are 2, 5, 8; the numbers in cells B1:B3 are 37, 45, 91; and the numbers in cells C1:C3 are 472, 644 and 1891. If I enter the formula: =SUM(A1:$B2) in cell D2, then drag it to cell D3, what number should I get in cell D3? A) 45 B) 82 C) 136 D) 149 3. Below is a bar graph of class standing for a seminar containing seven students who are either freshman, sophomores, juniors, or seniors. In the bar graph, the bar for the juniors has been omitted....
View Full Document
This note was uploaded on 03/20/2008 for the course STOR 155 taught by Professor Andrewb.nobel during the Spring '08 term at UNC.
- Spring '08