Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Get the Data and Import it to Excel Go to http://sealevel.colorado.edu/and find the data link below the figure labelled Raw data (ASCII). Right click on

image text in transcribed
Get the Data and Import it to Excel Go to http://sealevel.colorado.edu/and find the data link below the figure labelled "Raw data (ASCII)". Right click on this link and pick "Save Link As" to download the text file to your own computer. Open Excel and go to a blank sheet. In the data tab select Get External Data From Text. Select the data file from where ever you downloaded it to the computer. This will open the Text Import Wizard. In the step 1 box select the "Fixed Width" button. This is needed because the columns are not separated by commas in the text file. In the step 2 box select the Tab and Space as the delimiters. In step 3 keep the format as General. Click on Finish. The Import Data box can be kept to the default values (upper left cell in the existing workspace). Click OK and the data will now appears in two columns in your Excel Sheet

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

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

More Books

Students also viewed these Databases questions