{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

_Week2Lab_Excel - Welcome to Our First Lab for MATH 221...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Welcome to Our First Lab for MATH 221!!! These labs are designed to show you how to use Excel to help with statistical analysis. If you are familia Excel, that is great! If not, don't worry, we'll show you everything you need to know to successfully work t the labs. To start, this file contains several worksheets. The names "Accounts, Cereal, Milk Production, appear at the bottom. Each of these worksheets has an assignment for you to complete. Simply follow t instructions in yellow to complete each worksheet's assignment. Be sure to view the Tutorials that are associated with each lab. These Tutorials are interactive presentat someone actually using Excel to work through examples similar to the labs you are asked to do. What You Should Turn In: Each lab should consist of ONE file that you turn in. Use Excel to perform the calculations or generate th but then COPY-and-PASTE your work from Excel into Word . To Copy-and-Paste cells (or graphs) from Excel to Word: 1. Highlight the cells (or select the graph) in Excel you want to copy-and-paste 2. From the Excel menu, select Edit, then Copy 3. Go into Word and place the cursor where you want to paste your cells. 4. From the Word menu, select Edit, then Paste 5. Your work should have copied itself into Word. (Note: Can also right-click to select copy and/or paste.) Save your ONE Word file using the filename format "lastname_firstinitial_week#lab". For example, if Albert Einstein and you are submitting your Week 6 lab, the filename should be "einstein_a_week6lab".
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
ar with through " etc. the tions of he graph, you are
Image of page 2
9 7 5 10 14 15 1 3 3 1 3 3 10 11 12 9 11 11 9 1
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
AA 1 5 AB 2 8 AC 3 11 AD 4 12 AE 5 15 AF 6 15 AG 7 16 AH 8 17 AI 9 18 AJ 10 25 AK 11 43 AL 12 45 AM 13 48 AN 14 49 AO 15 50 AP 16 52 AQ 17 53 AR 18 65 AS 19 67 AT 20 74 AU 21 AV 22 AW 23 AX 24 AY 25 AZ 26 BA 27 BB 28 BC 29 BD 30 BE 31 BF 32 BG 33 BH 34 BI 35 BJ 36 BK 37 BL 38 BM 39 BN 40 BO 41 BP 42 BQ 43 BR 44 BS 45 BT 46 BU 47 BV 48 Account Name Random Sample Ordered Sample
Image of page 4
BW 49 BX 50 BY 51 BZ 52 CA 53 CB 54 CC 55 CD 56 CE 57 CF 58 CG 59 CH 60 CI 61 CJ 62 CK 63 CL 64 CM 65 CN 66 CO 67 CP 68 CQ 69 CR 70 CS 71 CT 72 CU 73 CV 74
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Instructions: Randomly select 20 of the accounts at left.
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern