Business Analytics
Business Analytics
3rd Edition
ISBN: 9780135231715
Author: Evans
Publisher: PEARSON
bartleby

Concept explainers

Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as p…
bartleby

Videos

Textbook Question
Book Icon
Chapter A4, Problem 2PE

Construct histograms using the Histogram chart for the gross sales and gross profit data in the Excel file Sales Data.

Expert Solution & Answer
Check Mark
To determine

To construct histogram for gross sales and gross profit.

Explanation of Solution

Given:

The data contains Customer, Percent gross, gross sales, gross profit, Industry code and competitive rating.

Following is the process to construct histogram for gross sales:

First select column of gross sales then click on

Insert→Charts→Histogram

Histogram for gross sales is:

  Business Analytics, Chapter A4, Problem 2PE , additional homework tip 1

The shape of the distribution of data is right skewed.

Following is the histogram for gross profit:

  Business Analytics, Chapter A4, Problem 2PE , additional homework tip 2

The shape of the distribution of data is right skewed.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Previous
Chapter 4, Problem 75PE
Next
Chapter A4, Problem 3PE
Students have asked these similar questions
AS2. NO10. DATA ANALYSIS
Make an analysis about the data gathered.
plot the frequency and cumulative frequency of the data

Chapter A4 Solutions

Business Analytics

Ch. A4 - Construct histograms using the Histogram chart for...Ch. A4 - For the Base Data in the Excel file Credit Risk...
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
SEE MORE TEXTBOOKS
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY