Purchase Solution

Histogram for pharmaceutical sales calls using Excel

Not what you're looking for?

Ask Custom Question

The number of weekly sales calls by a sample of 25 pharmaceutical salespersons is below:

25, 55, 45, 35, 37, 27, 29, 44, 34, 28, 33, 28, 46,31, 38, 41, 48, 38, 27, 29, 37, 33, 31, 40, 50

Construct a histogram in Excel and show all the formulas.

Purchase this Solution
Solution Summary

This solution is comprised of a step-by-step explanation of constructing a histogram in Excel.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Histogram and frequency distribution

    406628 Histogram The number of weekly sales calls by a sample of 25 pharmaceutical salespersons is below: 25, 55, 45, 35, 37, 27, 29, 44, 34, 28, 33, 28, 46,31, 38, 41, 48, 38, 27, 29, 37, 33, 31, 40, 50 Construct a histogram in Excel using this

  • Statistical Analysis

    Please refer to the Excel attachment. We have selected the variable 'Help Desk Calls' for the statistical analysis. Please refer to the EXCEL sheet for the numerical descriptive measures and the box-plot.

  • Statistics

    and associated frequency table for this data on Excel using bin values of 4, 8, 12, etc.

  • Drawing Conclusions for Ambulance Departments

    The times for each service to arrive at the scene were recorded using the following format: Column 1: call number for Cambridge calls Column 2: time in minutes for fire truck to arrive Column 3: time in minutes for the fire truck to arrive Column

  • Calculation of Frequency distribution and Histogram in Excel

    b) Using Excel, draw a histogram of the frequencies and paste it in the space provided below.

  • Descriptive Statistics and Histogram

    A detailed explanation is provided for all questions and the analysis is done using data analysis toolpack in excel.

  • Statistics Sampling Strategy

    The data set is given in Excel Sheet. The aim of the study is clear that most of the states in U.S. lie in which of the interval. A histogram will reveal the fact about the above. A histogram is given below for the data in Excel Sheet. 3.

  • Pfizer SWOT Analysis

    A smaller sales team can act more effectively in making sales calls productive, rather than obtrusive.

  • create a histogram

    384977 Creating a Histogram Obtain the mean and standard deviation for data attached and create a histogram for data frequencies using Microsoft Excel program.

View More Related Solutions