Complete Tasks 3 and 4 for Analytics

I’m studying for my class and don’t understand how to answer this. Can you help me study?

I have completed Assessments 1 and 2…PLEASE VIEW MY PREVIOUS ASSESSMENTS because all the assignments correlate with one another

You will complete Assessment 3 and 4

They are separate tasks so please upload them SEPARATELY

Introduction

Heartland Financial Inc. is financial institute that has continued to provide financial services for over twenty decades. The institute was established in 1981 where the founders had a vision of investing and growing the communities that were within the vicinity of the company. The company has continued to provide services not only to individuals but also to big corporates where is offers products such as commercial loans, retirement planning services, credit cards, checking and savings accounts. Through its operational years, the company has successfully succeed to merge with several bank creating one of the largest banking network in the country. The report analyzes the stock data of the company as it tries to elaborate how successfully the company has been in fulfilling its commitment and objectives. As a result, some of the measures that will be analyzed included the mean of the stock data, the median, and the standard deviation. Further, to practically depict the trend of the company, the report presents the data using two main graphs; the scatterplots and histogram. A sample of the stock data for a period of one year is presented in the table below.

The above table indicates the high and low prices that the stock of company attained during the month. In addition, for better understanding, it was deemed necessary to incorporate the total volume of stock that was traded during that entire period. To mean, median and standard deviation of the data is indicated in the table below. The values were tabulated in an excel document with the help of the inbuilt formulas.

Analysis

The Mean, Median and Mode are measures of central tendency that are used in statistical work to analyze data through the identification of the central position in any given data set. The mean is often used with both discrete and continuous data and is used to identify the central tendency of data. This is simply calculated by summing up the data set and dividing the population with the count number of the data. Therefore, according to the data, the mean is presented as 52.12, 46.33, and 2072000, respectively. This implies that values that fell below the set mean value did poorly as far as the stock price trends of the entire period. The median is another central tendency measure that is used to provide the middle score of the data set. It will often shed light on the location of the data sets. The median is a crucial central tendency measure since when compared to the mean it informs us about the distribution of the dataset. Therefore, in circumstances where the median and the mean are similar, the dataset is said to be more or less evenly distributed when considering the highest value in the dataset to the lowest value. Likewise, when there is a difference between the mean and median then the dataset is said not to be symmetrical hence skewed to either the right or left. When the mean is larger than the median the dataset is said to be skewed to the right. According to our dataset, the mean is larger than the median hence the dataset is skewed to the right. Finally, the standard deviation is a statistical measure that is used to indicate the measurement of a dataset and how the dataset is spread out from its mean. When the standard deviation value is low, then the dataset tends to deviate towards the mean.

References

Chen, J. (2010). Essentials of technical analysis for financial markets. New Jersey: John Wiley & Sons.

Fridson, M., & Alvarez, F. (2011). Financial Statement Analysis: A Practitioner’s Guide. Wiley.

https://finance.yahoo.com/quote/HTLF/history?period1=1531490195&period2=1563026195&interval=1mo&filter=history&frequency=1mo