Solution-Construct a histogram and a frequency polygon

Construct a histogram and a frequency polygon

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.

User Account

All Pages

Construct a histogram and a frequency polygon

Reference no: EM13832320

Reference no: EM13832320

Questions Cloud

Reviews

Write a Review

Mathematics Questions & Answers

Questions on ferris wheel

Logistic map

Finding the probability of cards

Systems of ode

Derive the boolean expression

System of equations

Linear programming problem

Find the natural domain

Introduction to numerical methods

Chart of the topological manifold

Mathematics in computing

Complex problems

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT