INU1511 Assignment Part B

By:

Studentâ€™s Name:

Institutional Affiliation

Course:

City:

Date:

INU1511 – Data Analysis

Investigation into the relationship between Profit and Sales

Variables

Descriptive Statistics

N

Minimum

Maximum

Sum

Mean

Std. Deviation

Variance

Skewness

Kurtosis

Statistic

Statistic

Statistic

Statistic

Statistic

Statistic

Statistic

Statistic

Std. Error

Statistic

Std. Error

Profits ($millions)

1999

-22400

59400

3406970

1704.34

3725.165

13876856.992

6.094

.055

63.289

.109

Valid N (listwise)

1999

Descriptive statistics shows a summary of the important metrics of a measure including maximum, minimum, mean, deviation, variance, skewness and kurtosis (Desagulier, G., 2017). The profit descriptive statistics above shows that the total profit obtained by the 2000 companiesâ€™ top listed firms totalled to $3,406,970 million and with an average profit of about $1704.34million. Out of the 2,000 companies, General Electric recorded the greatest loss of -$22,400 while the company that generated the most profit was Apple Company which amounted to $59,400. Out of the 2000 listed companies, 126 of them made losses amounting to -$159,265 while the rest 1874 companies made a profit amounting to $3,566,235 million. The line graph below shows the amount of profits obtained from different companies.

Sales

Sales is a discrete variable measured in million dollars ($). According to Schroeder, L.D., Sjoquist, D.L. and Stephan, P.E., (2016), a discrete variable is a form of a continuous variable which has been assigned a metric. In this case, the sales amount takes a sample of the 2000 top companies listed by Forbes and analysis the sales and profit obtained using in ($millions).

Summary statistics

Descriptive Statistics

N

Minimum

Maximum

Sum

Mean

Std. Deviation

Variance

Skewness

Kurtosis

Statistic

Statistic

Statistic

Statistic

Statistic

Std. Error

Statistic

Statistic

Statistic

Std. Error

Statistic

Std. Error

Sales ($millions)

1998

-9100

514400

41159357

20600.28

793.258

35457.852

1257259275.750

5.507

.055

45.233

.109

Valid N (listwise)

1998

The descriptive statistics shows that the total sales ($millions) obtained from the 2000 top companies listed by Forbes was equal to 41159357 with an average of about 20600.28. Phoenix Group Holdings recorded the least sales of -$9,100 million sales while Walmart of United States recorded the highest sales amount of $514400 million sales. Out of the 2000 listed companies, only 3 companies namely Phoenix Group Holdings, Quilter and St. James’s Place (all from United Kingdom) made negative sales records amounting to -$13,800. The other 1997 companies made a total of $41,145,557million sales revenue. The means sales ($millions) can be represented by the line graph below:

A bar graph would be most appropriate to compare companies in the technological sector to companies in the hospitality sector since it would highlight the length of the bars (representing the sales or profit level) of the company in the respective sector.