Questions
Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and...

Using Excel to Plot a Histogram

This exercise is to be completed using Microsoft Excel and will be turned in on Thursday, September

20th in class. You are to follow the steps we used in class on 9-13-2018 to construct the histogram

for the data consisting of the ages of the 50 most powerful women in the world from 2012 (Source:

Page 39 of textbook via Forbes Magazine). Your work should have columns for:

1. the raw data;

2. the data sorted in ascending order;

3. the maximum data value;

4. the minimum data value;

5. the range;

6. the class width using 7 classes;

7. the lower class limits;

8. the upper class limits;

9. the 7 classes themselves;

10. the frequency of the data within the 7 classes.

Your work should also include a picture of the corresponding histogram labeled as follows:

•Main Title:

“Age Distribution of the 50 Most Powerful Women for 2012 (new line) n = 50”

•Vertical Axis Title:

“Frequency”

•Horizontal Axis Title:

“Age Classes”

Please do not write on the paper to explain how to make this plot. PLEASE let me know the order what I should press to complete this plot in Excel. I need to finish this work in Excel, so I need easy and understandable explaination, such as what to press in to create class width in Excel something like that

This is Raw value to make this plot in Excel.

Raw Age Data
26
51
58
66
31
51
58
67
35
51
58
67
37
52
58
72
43
54
59
86
43
54
59
43
54
59
44
54
62
45
55
62
47
55
63
48
55
64
48
56
65
49
57
65
50
57
65
51
57
66

In: Statistics and Probability

Jiminy Cricket Removal has a profit margin of 11 percent, total asset turnover of 1.13, and...

Jiminy Cricket Removal has a profit margin of 11 percent, total asset turnover of 1.13, and ROE of 14.33 percent. What is this firm’s debt–equity ratio?

In: Finance

What type of market structure is the cricket ball product line of Kookaburra Sport fall under?...

What type of market structure is the cricket ball product line of Kookaburra Sport fall under? Would it be imperfect competition or an oligopoly? How would I determine this?

In: Economics

DNA polymerase can sometimes make mistakes. When this is detected the cell cycle halts and works...

DNA polymerase can sometimes make mistakes. When this is detected the cell cycle halts and works on repairing the mistakes. List two genes that, when their function is lost, would not allow cells to halt their cell cycle. Please explain in a sentence or two why the loss of function mutations in each gene would have this effect.?

In: Biology

A 54-year-old woman who has a history of COPD presents with a productive cough for the...

A 54-year-old woman who has a history of COPD presents with a productive cough for the last 3 months and shortness of breath with little exertion. Her blood pressure is 130/90 mm Hg and pulse rate 126 bpm. Arterial blood gas results are as follows: pH 7.29; PaCO2 72 mm Hg; HCO3– 34 mEq/L; PaO2 50 mm Hg.

How do you interpret the patient’s blood gas values?
What treatment would you anticipate?
Outline the nursing plan of care to address the patient’s fluid and electrolyte or acid–base disorders. Give the rationale for the nursing interventions for this patient.

In: Nursing

Two ordinary fair, six-sided dice ate rolled. What is the probability the sum of the numbers...

Two ordinary fair, six-sided dice ate rolled.
What is the probability the sum of the numbers on the two dice is 6, given that the number on at least one of the dice is 3?
What is the probability the sum of the numbers on the two dice is 8, given that the number on at least one of the dice is 3?
What is the probability that the sum of the numbers on the two dice is 9, given that it is not 3?
What is the probability that exactly one of the dice shows the number 1 given that the sum of the number is 3?

In: Statistics and Probability

Problem 3 - Bonds Suppose we sell an 8 year bond, with coupon rate =7 %....

Problem 3 - Bonds
Suppose we sell an 8 year bond, with coupon rate =7 %.
The face value of the Bond is $1000. The market rate is 8 %.
1. What is the price of the bond ?
2. What is the interest expense in the first two years ?

In: Accounting

An amusement park studied methods for decreasing the waiting time (minutes) for rides by loading and...

An amusement park studied methods for decreasing the waiting time (minutes) for rides by loading and unloading riders more efficiently. Two alternative loading/unloading methods have been proposed. To account for potential differences due to the type of ride and the possible interaction between the method of loading and unloading and the type of ride, a factorial experiment was designed. Use the following data to test for any significant effect due to the loading and unloading method, the type of ride, and interaction. Use α = 0.05.

Type of Ride
Roller Coaster Screaming Demon Log Flume
Method 1 41 52 50
43 44 46
Method 2 49 50 48
51 46 44

Find the value of the test statistic for method of loading and unloading.

_____________.

Find the p-value for method of loading and unloading. (Round your answer to three decimal places.)

p-value = _________.

Find the value of the test statistic for type of ride.

____________.

Find the p-value for type of ride. (Round your answer to three decimal places.)

p-value = __________.

Find the value of the test statistic for interaction between method of loading and unloading and type of ride.

____________.

Find the p-value for interaction between method of loading and unloading and type of ride. (Round your answer to three decimal places.)

p-value = _____________.

In: Statistics and Probability

Below are the closing values and daily return on the S&P 500 for the last ten...

Below are the closing values and daily return on the S&P 500 for the last ten days. What are the daily and annualized standard deviations? You may use excel for this problem. Enter your answers as percent rounded to two decimal places.

Date Closing value Return
9/25/2019 2984.87 0.0062
9/26/2019 2977.62 -0.0024
9/27/2019 2961.79 -0.0053
9/30/2019 2976.74 0.0050
10/1/2019 2940.25 -0.0123
10/2/2019 2887.61 -0.0179
10/3/2019 2910.63 0.0080
10/4/2019 2952.01 0.0142
10/7/2019 2938.79 -0.0045
10/8/2019 2893.06 -0.0156

In: Finance

Fashionisto Inc. is an upscale clothing store in New York City and London. Each store has...

Fashionisto Inc. is an upscale clothing store in New York City and London. Each store has two main departments, Men’s Apparel and Women’s Apparel. Marie Phelps, Fashionisto’s CFO, wants to use strategic performance measurement to better understand the company’s financial results. She has decided to use the profit center method to measure performance and has gathered the following information about the two stores and the two departments of the New York City store:

Total net sales $ 4,500,000
Fixed costs
Partly traceable and controllable 300,000
Partly traceable but noncontrollable 270,000
Nontraceable costs 120,000
Total net sales (percent)
London store 40 %
New York store 60
New York—Men’s Apparel 40
New York—Women’s Apparel 60
Cost of goods sold—variable (percent of sales)
London store 52 %
New York—Men’s Apparel 45
New York—Women’s Apparel 60
Variable operating costs (percent of sales)
London store 36 %
New York—Men’s Apparel 22
New York—Women’s Apparel 32
Fixed controllable costs—partly traceable (percent of total)
London store 40 %
New York total 40
Men’s Apparel 45
Women’s Apparel 40
Could not be traced to Men’s or Women’s Apparel 15
Could not be traced to London or New York 20
Fixed noncontrollable costs—partly traceable (percent of total)
London store 50 %
New York total 40
Men’s Apparel 35
Women’s Apparel 15
Could not be traced to Men’s or Women’s Apparel 50
Could not be traced to London or New York 10

Required:

1. Using this information, prepare a contribution income statement for Fashionisto.

In: Accounting