# 3 excel problem | StudyDaddy.com

2. The file P02_02.xlsx contains information on over 200 movies that were released in 2006 and 2007.

Create two column charts of counts, one of the different genres and one of the different distributors.

Recode the Genre column so that all genres with a count of 10 or less are lumped into a category called Other. Then create a column chart of counts for this recoded variable. Repeat similarly for the Distributor variable.

3. The file P02_03.xlsx contains data from a survey of 399 people regarding a government environmental policy.

Which of the variables in this data set are categorical? Which of these are nominal; which are ordinal?

For each categorical variable, create a column chart of counts.

Recode the data into a new data set, making four transformations:

(1) change Gender to list “Male” or “Female”;

(2) change Children to list “No children” or “At least one child”;

(3) change Salary to be categorical with categories “Less than \$40K,” “Between \$40K and \$70K,” “Between \$70K and \$100K,” and “Greater than \$100K ” (where you can treat the breakpoints however you like); and

(4) change Opinion to be a numerical code from 1 to 5 for Strongly Disagree to Strongly Agree.

Then create a column chart of counts for the new Salary variable.

4. The file P02_04.xlsx contains salary data on all Major League Baseball players for each year from 2002 to 2011. (It is an older version of the data used for examples later in this chapter.) For any three selected years, create a table of counts of the various positions, expressed as percentages of all players for the year. Then create a column chart of these percentages for these years. Do they remain fairly constant from year to year?

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.