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.