Construct a histogram and a frequency polygon

Assignment Help Mathematics
Reference no: EM13832320

Use Excel to answer the following questions.

1. Construct a histogram and a frequency polygon for the following data.

Class Interval

Frequency

30-under 32

5

32-under 34

7

34-under 36

15

36-under 38

21

38-under 40

34

40-under 42

24

42-under 44

17

44-under 46

8

2. Are the advertising dollars spent by a company related to total sales revenue? The following data represent the advertising dollars and the sales revenues for various companies in a given industry during a recent year. Construct a scatter plot of the data from the two variables and discuss the relationship between the two variables.

Advertising (in $millions)

Sales (in $millions)

4.2

155.7

1.6

87.3

6.3

135.6

2.7

99.0

10.4

168.2

7.1

136.9

5.5

101.4

8.3

158.2

Reference no: EM13832320

Questions Cloud

Prepare a customer profitability analysis ranking the firms : Calculate the customer level operating profit for each of the above merchandising firms based on the actual number of orders written.
Explain what were some of the credit risks that arose : What were some of the credit risks that arose from the 2008 financial crisis. How were banks affected by the credit risks. How were individuals and businesses affected by the credit risks
Evaluate the board''s philosophy on executive compensation : Evaluate the board's philosophy on executive compensation. Discuss the metrics tied to the CEO's inventive compensation. Are they sound metrics or not. Determine if compensation is reasonable considering the company's financial performance.
Evaluate varying interpretations of developmental models : Analyze the impact of culture on attachment and cognitive and moral reasoning developmental models. Evaluate varying interpretations of developmental models across cultures
Construct a histogram and a frequency polygon : 1. Construct a histogram and a frequency polygon for the following data.
Identify the ethical principles violated : Identify the ethical principles violated - In each discussion-excerpt above identify the specific threat to independence.
Optimize revenue and control costs : Measure the financial performance of these companies and describe their current performance. In the presentation, include the business tracking tools you used to perform the measurement. Include a description of which trends were monitored and analyz..
Compute the complete payoff table : Compute the complete payoff table. (Firm A has four possible allocations: 3-0, 2-1, 1-2, and 0-3. Firm B has three allocations: 2-0, 1-1, and 0-2). Is this a constant-sum game? Explain.
Provide details of your scope of engagement : Provide details of your 'scope of engagement' (i.e. what exactly were you instructed to do). Critically analyse the current understanding of CSR, referring to academic literature and industry standards.

Reviews

Write a Review

Mathematics Questions & Answers

  Explain math anxiety disorder

Pretend you are a specialist in "Math Anxiety Disorder" and you have a group of students who have signed up for therapy because they are starting a Math class in one week and they have not taken Math in 10 years!

  What is the velocity of the body

Kinetic energy varies jointly as the mass and the square of the velocity. A certain body has a mass of 5 grams and an energy of 40 joules at a velocity of 4 meters per second. What is the velocity of the body when its energy is 90 joules?

  Graphical method

Formulate the above as linear programming problem. Solve (a) by graphical method.  Solve using simplex method.

  Rules of inference to derive the conclusion

If women are by nature either passive or uncompetitive, then it is not the case that there are lawyers who are women. If men are by nature either insensitive or without the ability to nurture, then it is not the case that there are kindergarten te..

  What month are you starting the model from

Where are you getting 300 from? What month are you starting the model from?

  Identifying as well recognizing variations in sets

Identifying and Recognizing Variations in Sets, I am currently working on sets and how to identify/recognize variations based on symbols. Is there any kind of "outline" or list/reference that I can utilize to better understand their core meaning?

  How to solve 8-3(x+1)=5-(2x-3) what is the process

How to solve 8-3(x+1)=5-(2x-3) what is the process?

  Finding thenbsp probability from the given dataa package

finding thenbsp probability from the given dataa package contains 9 candy canes 6 of which are cracked. if 2 are

  Hypothesis test for population mean

Hypothesis test for population mean

  Discuss whether this problem is describing a binomial

consider the following problema top nhl hockey player scores on 93 of his shots in a shooting competition. what is the

  Express the combined area of the two squares

A piece of wire 4 m long is cut into two pieces, then each piece is bent into a square. Express the combined area of the two squares in terms of one variable x

  What is the speed of the plane in still air

A plane flies 430 miles with the wind and 310 miles against the wind in the same length of time. If the speed of the wind is 30mph, what is the speed of the plane in still air?

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