Answered step by step
Verified Expert Solution
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 and 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 TableRange put in the column containing RandNumb, it may be E:E 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 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 LastNameLabTaskpng 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started