Data analysis using the tally function

Assignment Help Database Management System
Reference no: EM132238752

Analysis 1

Background: This assignment focuses on data analysis using the tally() function. You must be able to analyze data before you try to present data through visualizations.

Assignment:

Use RStudio and R Markdown to generate a Word document with the R commands and answers to all of the data analysis questions listed below.

Submit only one document with all of your answers.

Follow the formatting requirements identified in the Install R Markdown video in Week 2.

Follow the data analysis instructions provided in the videos this week.

Use the appropriate dataset for each question. All required datasets are available on Blackboard at the bottom of this week.

Use the tally() function to produce the correct answer for each of the questions listed below.

Carefully choose the correct field operators and logical operators when writing the tally() function.

In your final Word document, circle the correct answer for each question when the results of the tally() function create a table rather than a single answer. Failure to circle the correct answer will result in zero points for that question.

Questions:

1) What percentage of females purchased a 2nd class ticket in the dataset?

2) What percentage of males purchased a 1st class ticket and survived in the dataset?

3) What percentage of males purchased a 2nd class or 3rd class ticket in the dataset?

4) What percentage of males paid for meals under $17.50 are in the dataset?

5) What percentage of males paid for meals on Saturday that was over $17.50 are in the dataset?

6) What proportion of males and females never smoked in the dataset?

7) What proportion of females do not exercise and do smoke in the dataset?

8) What proportion of males and females never smoked and exercise frequently in the dataset?

9) What percentage of petal length are greater than and equal to 4.5?

10) What proportion of species have petal widths greater than 1.0 in the dataset?

Attachment:- dataset price personal computers.rar

Reference no: EM132238752

Questions Cloud

Costly method of moving product that is not gaseous : Generally the least costly method of moving product that is not gaseous, liquid, or slurry is:
What steps could be taken to build staff confidence : How can Laura most effectively use both management and leadership skills in her role as associate director?
Design a single digit counter in base 4 that can be joined : Design a single digit counter in base 4 that can be joined up to other modules to count to larger numbers. The modules must follow the specified design so that they are compatible with modules designed by other groups. Each of the 2 light input signa..
Discuss the pros and cons in business with china and mexico : Mexico and China are both popular destinations for outsourcing, foreign direct investments and offshoring.
Data analysis using the tally function : What percentage of females purchased a 2nd class ticket in the dataset - What percentage of males paid for meals on Saturday that was over $17.50
Assume that asynchronous transmission is used with 1 start : A data source produces 7-bit IRA (International Reference Alphabet) characters. Suppose a file of 10,000 IRA characters is to be sent over a line at 4800 bps. Assume that asynchronous transmission is used with 1 start bit, 1 stop bit and 1 parity bit..
Leaders are born and not made also give suitable examples : Leaders are born and not made. also Give suitable examples
Discuss one cognitive or one pharmacological therapy : Discuss one cognitive or one pharmacological therapy you feel has significant potential in treating clients. Identify a disorder that it is used as a treatment.
Derivation and right most derivation : What is the different between left most derivation and right most derivation

Reviews

Write a Review

Database Management System Questions & Answers

  Build a distributed data storage system

You have been hired to build a distributed data storage system for property sales agency that will allow its employees to store, access and update information

  Find the destinations employees have traveled to

Write an SQL statement for each of the following. Find the destinations employees have traveled to. Find the most commonly used category code

  Explain a scenario where would apply access control measures

Explain a scenario where you would apply one of the four access control measures. Why would you select one over the others?

  Metropolis toys metropolis toys is an independent

metropolis toys metropolis toys is an independent family-owned manufacturer of wooden toys. the toys are designed by

  Identify key stakeholder expectations for the new technology

Case Study on Maryland Technology Consultants (MTC).MTC is a fictional company created for IFSM 300's Case Study - review the provided Vendor brochure

  Contents of the product table

To list all the contents of the PRODUCT table, you would use and When you issue the DELETE FROM tablename command without specifying a where condition

  Er diagram of cardinality and modality

ER Diagram of cardinality and modality bank management system and discription of bank management system

  Use sql to create and drop tables.

Include the SQL statements and screenshots of your new tables in the paper.

  Relational databases are more efficient and effective

Describe why relational databases are more efficient AND effective for data management in organizations. How does the task of data normalization help to achieve these goals?

  What is a recursive join

Explain why the following two commands produce different results: SELECT DISTINCT COUNT (V_CODE) FROM PRODUCT; SELECT COUNT (DISTINCT V_CODE) FROM PRODUCT.

  Design and implement the best home business database

In this assignment, you are to design and implement The Best Home business database that you have modelled in the assignment-1 and a series of SQL queries to reflect the business logic of The Best Home

  Create erd models

Select one of the Real World Scenarios and use the experience you have that is related to the scenario you have chosen or research online; and then post your comments and solutions about your experience.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd