Question: On Excel, when I am using a histogram to input data to make a chart, how do I make a histogram? I have the histogram

On Excel, when I am using a histogram to input data to make a chart, how do I make a histogram? I have the histogram template but I don't know what functions to use to actually separate the bars and make the heights different. And on the horizontal axis, I am having a hard time putting the specific data there because it won't let me input anything except one number. This is what it looks like lol.. and I have an example of what its supposed to look like but I cant get it. Also on the vertical access it's supposed to be 0-40 and I was able to do it one time but as I kept messing with it, i lost it and I can't remember how to place the numbers on the horizontal access either.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

I need help to the excel IMPLEMENTATION Use Table 10.1 and Figure 10.1 to help you understand the parameter values and to enter the employees' input data correctly. Make sure you format the numeric...

Objectives Design an Activity-Based Costing system for a supply chain Analyze a business case, recognizing how to deal with customers based on their contribution to the cost Assessing customer...

Part 1 Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recor Possible points Points earned Five year inflation rate 10 Projection of expenses in...

JOHNSON BEVERAGE, INC. As president and primary owner of Johnson Beverage, Inc. (JBI), Jack Johnson was beginning to realize that retaining long-term customers was becoming a challenge. During a...

Help me do this assignment by guiding me step by step to complete everything, provide me guide question that I have to complete. So basically I need a step by step guide (as detailed as possible) to...

In this first lab assignment of the course you will be performing several types of analysis on a company's financial statements, including a horizontal analysis, vertical analysis, and ratio...

Please solve this Model question on excel and provide the formula on how to do it: You are thinking of opening a Broadway play, I Love You, Youre Mediocre, Now Get Better! It will cost $7 million to...

3 of 20 Class Frequency 27-32 33-38 39-44 11 45-49 4 50-55 2 Why is this distribution incorrect? O Classes should be overlapped. O The frequencies are skewed. The fourth class width is different from...

Objectives Design an Activity-Based Costing system for a supply chain Analyze a business case, recognizing how to deal with customers based on their contribution to cost Assessing customer...

Why is it necessary for companies to manage their inventory? Businesses that can manage and account for their inventory have accurate data to make informed decisions. For example, inventory...

Find the court decision located at T. C. Summary Opinion 2006-20. a. Which court heard the case? b. Who was the judge(s)? c. Which tax year(s) is in question and in what year was the case decided? d....

In the marketing communication process, what are the various dimensions of the source, the message, and the receiver?

2. Should the source used in such a manufacturing process have a short or a long half-life? Explain your answer. Radioactive sources are used to control thickness in some manufacturing processes.

13. Stock Valuation (LO1) Taleville Farms just paid a dividend of $3.20 on its stock. The growth rate in dividends is expected to be a constant 5% per year indefinitely. Investors require a 15%...

e. In how many cases were people depicted in stereotypical rolesfor example, African Americans as athletes, or women as homemakers?

1. Discuss the four components of language.

a. How many different groups were represented?