Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Copy and paste the data into an Excel spreadsheet. If the data does not separate into individual columns when you paste: Make sure the data

Copy and paste the data into an Excel spreadsheet.
If the data does not separate into individual columns when you paste:
Make sure the data is still highlighted within excel.
Click Data tab.
Click Text to Columns icon.
A window should pop up. Click Delimited, then click Next.
On the upper left of the next page, make sure the option Space is selected, then click Finish.
Your data should now be separated into individual cells.
Create a frequency table displaying the number students who chose a given number (between 1 and 10). We'll do this with a Pivot Table.
Click in an empty cell to the right of the data
In the Insert tab, choose the Pivot Table icon (likely to be on the far left). Choose Pivot Table from the drop down menu.
For the Table/Range, put in the column containing RandNumb, it may be E1:E191. Click OK.
A pop up on the far right should appear. Check the box next to RandNumb to add the field to the report.
Drag the RandNumb from the field list down to the Row (or Axis) Labels area.
On the Values area, make sure it says Count of Random Number. If not, click the arrow by Sum of RandNumb and choose Value Field Settings from the menu. Change this to Count and click OK
Be sure RandNumb is still in your Row label and close the Pivot Table window
Capture an image of the table and upload it in the Lab 1 Upload assignment (there will be three images for this lab, so you can upload them together at the end). Use a file name along the lines of LastNameLab1Task1.png (saving as a jpg is OK too)
Referring to the frequency table you created, what is the number most frequently selected by the students?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

discuss different sources of numerical data;

Answered: 1 week ago

Question

What are Electrophoresis?

Answered: 1 week ago