Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm not even sure where to start. any help would be much appreciated. thank you. mydata.csv is the data set labeled mtcars(1) Please submit in

I'm not even sure where to start. any help would be much appreciated. thank you.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
mydata.csv is the data set labeled mtcars(1)
Please submit in Word or PDF. You can either copy/paste both command and execution result or take screenshot of each step. 1. Create a directory called Plab in CS 2. Download mydata.csy from D2L and save dataset in C:VALab. 3. Set your working directory - From Console window: File > Change dir... In Console, type: "dir:()" 4enters You should see your file there you've saved as "mydata.csv" 4. Load and view your data. > read.csv("mydata.csv") | 5. Do it again, but load it into a variable named "data" and then view it by just typing "data". 6. Now you're ready to start manipulating the data by pulling out only subset of it. Pulled out Ozone column into a vector. 7. Look at it by typing in the variable object "oz" and senters 8. Now let go find all the values in 0z where we have no data (1.e. "WA") and let's put that into a vector object called "badoz": 9. Now let's use "oz" and "badoz" to give me everything in the Ozone column ("oz") thitat DOESN'T have bad data by using the exclamation character with means "NOT this thing". You've just filtered out a whole column and then eliminated all the bad data from that column into lit's own data set. 10. Let's find the average of this data set. 11. Let's get a summary. 12. Make another subset of data from the original where Ozone was more than 31 and Temperature was over 90 degrees. 13. Let's get only the month of May into a subset. mtcars (1) \begin{tabular}{|l|r|r|r|r|r|r|r|r|r|r|r|} \hline Toyota Corona & 21.5 & 4 & 120.1 & 97 & 3.7 & 2.465 & 20.01 & 1 & 0 & 3 & 1 \\ \hline Dodge Challenger & 15.5 & 8 & 318 & 150 & 2.76 & 3.52 & 16.87 & 0 & 0 & 3 & 2 \\ \hline AMC Javelin & 15.2 & 8 & 304 & 150 & 3.15 & 3.435 & 17.3 & 0 & 0 & 3 & 2 \\ \hline Camaro Z28 & 13.3 & 8 & 350 & 245 & 3.73 & 3.84 & 15.41 & 0 & 0 & 3 & 4 \\ \hline Pontiac Firebird & 19.2 & 8 & 400 & 175 & 3.08 & 3.845 & 17.05 & 0 & 0 & 3 & 2 \\ \hline Fiat X1-9 & 27.3 & 4 & 79 & 66 & 4.08 & 1.935 & 18.9 & 1 & 1 & 4 & 1 \\ \hline Porsche 914-2 & 26 & 4 & 120.3 & 91 & 4.43 & 2.14 & 16.7 & 0 & 1 & 5 & 2 \\ \hline Lotus Europa & 30.4 & 4 & 95.1 & 113 & 3.77 & 1.513 & 16.9 & 1 & 1 & 5 & 2 \\ \hline Ford Pantera L & 15.8 & 8 & 351 & 264 & 4.22 & 3.17 & 14.5 & 0 & 1 & 5 & 4 \\ \hline Ferrari Dino & 19.7 & 6 & 145 & 175 & 3.62 & 2.77 & 15.5 & 0 & 1 & 5 & 6 \\ \hline Maserati Bora & 15 & 8 & 301 & 335 & 3.54 & 3.57 & 14.6 & 0 & 1 & 5 & 8 \\ \hline Volvo 142E & 21.4 & 4 & 121 & 109 & 4.11 & 2.78 & 18.6 & 1 & 1 & 4 & 2 \\ \hline \end{tabular} Please submit in Word or PDF. You can either copy/paste both command and execution result or take screenshot of each step. 1. Create a directory called Plab in CS 2. Download mydata.csy from D2L and save dataset in C:VALab. 3. Set your working directory - From Console window: File > Change dir... In Console, type: "dir:()" 4enters You should see your file there you've saved as "mydata.csv" 4. Load and view your data. > read.csv("mydata.csv") | 5. Do it again, but load it into a variable named "data" and then view it by just typing "data". 6. Now you're ready to start manipulating the data by pulling out only subset of it. Pulled out Ozone column into a vector. 7. Look at it by typing in the variable object "oz" and senters 8. Now let go find all the values in 0z where we have no data (1.e. "WA") and let's put that into a vector object called "badoz": 9. Now let's use "oz" and "badoz" to give me everything in the Ozone column ("oz") thitat DOESN'T have bad data by using the exclamation character with means "NOT this thing". You've just filtered out a whole column and then eliminated all the bad data from that column into lit's own data set. 10. Let's find the average of this data set. 11. Let's get a summary. 12. Make another subset of data from the original where Ozone was more than 31 and Temperature was over 90 degrees. 13. Let's get only the month of May into a subset. mtcars (1) \begin{tabular}{|l|r|r|r|r|r|r|r|r|r|r|r|} \hline Toyota Corona & 21.5 & 4 & 120.1 & 97 & 3.7 & 2.465 & 20.01 & 1 & 0 & 3 & 1 \\ \hline Dodge Challenger & 15.5 & 8 & 318 & 150 & 2.76 & 3.52 & 16.87 & 0 & 0 & 3 & 2 \\ \hline AMC Javelin & 15.2 & 8 & 304 & 150 & 3.15 & 3.435 & 17.3 & 0 & 0 & 3 & 2 \\ \hline Camaro Z28 & 13.3 & 8 & 350 & 245 & 3.73 & 3.84 & 15.41 & 0 & 0 & 3 & 4 \\ \hline Pontiac Firebird & 19.2 & 8 & 400 & 175 & 3.08 & 3.845 & 17.05 & 0 & 0 & 3 & 2 \\ \hline Fiat X1-9 & 27.3 & 4 & 79 & 66 & 4.08 & 1.935 & 18.9 & 1 & 1 & 4 & 1 \\ \hline Porsche 914-2 & 26 & 4 & 120.3 & 91 & 4.43 & 2.14 & 16.7 & 0 & 1 & 5 & 2 \\ \hline Lotus Europa & 30.4 & 4 & 95.1 & 113 & 3.77 & 1.513 & 16.9 & 1 & 1 & 5 & 2 \\ \hline Ford Pantera L & 15.8 & 8 & 351 & 264 & 4.22 & 3.17 & 14.5 & 0 & 1 & 5 & 4 \\ \hline Ferrari Dino & 19.7 & 6 & 145 & 175 & 3.62 & 2.77 & 15.5 & 0 & 1 & 5 & 6 \\ \hline Maserati Bora & 15 & 8 & 301 & 335 & 3.54 & 3.57 & 14.6 & 0 & 1 & 5 & 8 \\ \hline Volvo 142E & 21.4 & 4 & 121 & 109 & 4.11 & 2.78 & 18.6 & 1 & 1 & 4 & 2 \\ \hline \end{tabular}

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

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

What are the types of forms of communication ?

Answered: 1 week ago