01 Jul this is a business statistics hw need to be answered in excel
Question Description
PRESENTING STATISTICAL DATA
The purpose of these case studies is to demonstrate your ability to develop relatively routine
presentation graphics for analytical studies. You may refer to Chapter 2-R as needed, or to any
other source. Prepare these as if you were an entry level analytics analyst for an organization, and
are going to present these to a staff meeting of middle managers.
Case Study 2.1
The US government National Center for Education Statistics publishes a “Digest of Education
Statistics” which shows the number of adults 18 years of age and older having attained each level of
academic degree. Find the appropriate website, and produce a pie chart showing the number of
adults age 18 and older in the United States having the following as their highest level of education
attained.
Ph.D.
Master’s Degree
Bachelor’s Degree
Associate’s Degree
Some College, No Degree
High School Degree
No Degree
You are free to build the chart in a way convenient for you as long as the following standards are
met. Upload the spreadsheet and chart to Canvas by the time frame required.
It must be a form of three-dimensional pie chart.
It must not use the colors red, yellow, or green for the pie segments.
Each segment must be labeled with both the number of people in the segment, and the name of the segment. Optionally, labeling can be partly from the chart legend.
All labeling must be in bold, 12 pitch Arial font.
The pie chart title must be in bold, 16 pitch Arial font. The title must also convey the year of the data retrieved and the data source; put this in the second line with 12 pitch, bold, Arial font.
The “message” of the pie chart must be understandable to a viewer within 3-5 seconds of being displayed.
Case Study 2.2
Choose a US-based industry having many competitors. For example, the fast food industry has many competitors, the auto industry has many competitors, as with the tire industry. Build a histogram showing last year’s sales of each of the top five sales leaders in that industry to include the amount of sales for each company. You are free to build the chart in a way convenient for you as long as the following standards are met. Upload the spreadsheet and chart to Canvas by the time frame required.
It must be a form of two-dimensional histogram (Excel’s “column” chart).
It must not use the colors red, yellow, or green for the bars.
Order the companies, left to right, having the highest to lowest sales revenues.
Each bar must be labeled with both the name of the company and last year’s sales revenue in the bar label. Optionally, labeling can be partly from the chart legend; the chart must have a legend. The legend must be in 10 pitch, bold, Arial font.
All other labeling must be in bold, 12 pitch Arial font.
Label the x and y axes.
The histogram title first line must be in bold, 16 pitch Arial font. The title must also convey the year of the data retrieved and the data source; put this in the second line with 12 pitch, bold, Arial font.
The histogram “plot area” must be colored or patterned.
The “message” of the histogram must be understandable to a viewer within 3-5 seconds of being displayed.
Is the data from the correct source. 2 pts. _____
Is the chart in the correct format. 1 pt. _____
Does the chart not use the colors red, yellow, or green for the pie segments or bars. 1 pt. _______
Are each segment or bar labeled with both the data value and the name. Optionally, labeling can be partly from the chart legend. 2 pts. ______
Is all required labeling present, and in bold, 12 pitch Arial font. 1 pt. ______
Is the chart title in bold, 16 pitch Arial font. Does the title must also convey the year of the data retrieved and the data source; put this in the second line with 12 pitch, bold, Arial font. 1 pt. _____
The “message” of the chart must be understandable to a viewer within 3-5 seconds of being displayed. 1 pt. _____
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.