Develop a histogram for the data using excel

Assignment Help Business Management
Reference no: EM133019918

Develop a histogram for the following data using excel

 

Develop two separate histograms for hours of overtime and days absent. How do the data appear to be distributed?

 

After that, Using the data in Problem 7, develop a scatter plot of hours of overtime versus days absent. Do the data overtime hours and days absent appear to be correlated?

 

Employees 1-30

 

Hours of Overtime Days Absent

 

243 3

 

126 2

 

86 0

 

424 6

 

236 3

 

128 0

 

0 0

 

126 2

 

324 3

 

118 0

 

62 0

 

128 3

 

460 6

 

135 1

 

118 1

 

260 2

 

0 1

 

126 1

 

234 2

 

246 3

 

120 1

 

80 0

 

112 1

 

237 3

 

129 2

 

24 1

 

36 0

 

128 2

 

246 3

 

326 6

Reference no: EM133019918

Questions Cloud

What type of organisational structure : What type of organisational structure does new balance(popular shoe brand) follow and explain it briefly.
Analyse any five types of risks : The Dragons' Den television series features a number of potential entrepreneurs pitching their innovative business ideas to a panel of venture capitalists. The
Who are the actors in this process : Every purchase that Ford would make needed to go through the purchasing department. Who are the actors in this process
Organization outlook and marketing activities : In what way do the following economic variables influence an organization's outlook and marketing activities: trends in gross domestic product, interest rates,
Develop a histogram for the data using excel : Develop two separate histograms for hours of overtime and days absent. How do the data appear to be distributed?
At what amount should the receivable from the vice-president : On January 1, 2020, Ironbank grants a 10-year P10,000,000 non-interest bearing advance to its vice-president. At what amount should the receivable
Find on records ready to be stored : What kinds of release marks might you find on records ready to be stored?
Describe and analyze the main capital budgeting techniques : Describe and analyze the main capital budgeting techniques. Which techniques do you think would be more effective in an IT department
What is globalization : What is globalization? Do you think it's a good thing or bad thing for business? Explain

Reviews

Write a Review

Business Management Questions & Answers

  Most significant byte or the least significant byte

From the value, how can you know what is considered the most significant byte or the least significant byte?

  Identify barriers to coaching displayed by marissa

Identify 5 barriers to coaching displayed by Marissa and suggest how Eric might overcome each of them?

  The financial and/or business aspects

The financial and/or business aspects.

  What is the value of their investment today

ABC Corporations want to invest R15 000 annually at the beginning of the period with the hope of expanding in 10 years' time.

  Tafes and other educational organisations

What assistance can you get from Universities, TAFEs and other educational organisations?

  Social network for work-related reasons

Have you ever used a social network for work-related reasons? If so, describe your experience and whether you feel your use of social networking improved your effectiveness in reaching organizational goals. (If you have never used a social network..

  Determine the total cost of ownership

Determine the total cost of ownership (TCO) and total benefits of ownership (TBO) for purchasing, maintaining, and supporting a personal computer.

  Programmer the difference between pp and opp

If you were to explain to a beginning programmer the difference between PP and OPP, what analogies or examples would you use?

  Instructional design amp rapid e-learningidentify

instructional design amp rapid e-learningidentify characteristics of good instructional design. why are these

  Triple bottom line of economic

Sustainability is often called a Triple Bottom Line of economic, environmental, social performance. Note that sustainability, and particularly the social dimension, is a continually important issue.

  What is the optimal profit

c)The daily demands represent minimum sales commitments, but all output can be sold. In other words, the model should permit the production to exceed the daily

  Why is preparation and information

Explain how and/or why is preparation and information also an important source of power?

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