According excel data write a analysis paper about the clothing Company Buckle In, statistics homework help

Anonymous
timer Asked: Apr 14th, 2017
account_balance_wallet $9.99

Question Description

According to analysis excel data to write a paper.

Guideline:

Most use regression or forecasting. determining settings in a production process, analyzing state data to predict crime rates, forecasting sales and predicting the profit and something related to Buckle In company!

The paper need

1. Introduction – includes a detailed description of the problem and motivation for the study.

2. Variables used in the study, like Independent Variable and Dependent Variable

3. Data Analysis – includes all necessary computer output.

4. Interpretation and limitations of study

5. Summary/Conclusions 6 references about paper (not include that data references on the file)


File .

In the file, it gonna mentioned Dependent Variable will be Monthly Sales and Independent Variable like: collecting the data for Number of Stores, Unemployment, Consumer Sentiment Index, and Inflation. Also regression of each one of those variables against Net Sales. What's more, regression using all variables and generated a Correlation Matrix.

Tutor Answer

Dr_Schrodinger
School: Cornell University

Here you go buddy,please do check

Surname1

Course title
Professor’s name
University affiliation
Date
Introduction
Most companies aims at maintaining stability and growth annually. The overall growth in
the company is contributed by the sales and the consumption of goods in the company. Buckle
Inc. is one of the company that is undergoing a major financial problems annually based on the
annual statistical analysis (Plunkett 56). The company is struggling to keep the consumers
engaged due to the high prices of its products. There is an overall decline in store sales and
mixed record of earnings from 2013 to 2016.The sales momentum in the retail company tend to
shift because it trades at a steep discount. The motivation behind the study is the slow growth
within Buckle Inc. clothing company. Due to the overall poor performance of the company, it
was likely that the shares were put under pressure (Terrell 89). Shareholders would not invest in
a company which does not show any signs of growth. The study will give the company a better
chance of forecasting effectively and reflect on how to improve on the overall sales momentum.
Variables used
There are different variables that are used in the study. Independent variables are values
that can be manipulated in the study and are used to make a prediction on the outcomes (Mergent
FIS & Mergent, Inc 217). Dependent variables are not changed. They are the main outcomes of a
study. The independent variable that has been used in the study is monthly sales. Dependent

Surname2
variables include; net sales, number of stores, inflation rate, unemployment rate and consumer
sentiment index.
Data analysis
Generally, Buckle Inc. shows an overall slow growth over the last four years. The
company shows a mixed in annual sales. There is a consistent revenue miss, with the company
falling short nearly on every quarter. It is very clear that the inflation rate is below 0 which is a
disaster to the company. It is likely to affect the prices of goods and therefore the number of
consumers who will be purchasing from the company (Standard & Poor's Stock Reports 28).Net
sales from the company shows a general mix in gains and losses from 2013 to 2016.

There was an increase of 0.11% in net sales between 2013 and 2014 but dropped to 2.22% between 2014 and 2015.It recorded the lowest growth of -12.57% between the year 2015
and 2016.

The Buckle, Inc. Net Sales 2016
Net Sales (Millions)

200
150
100
50
0
0

2

4

6

8

10

12

14

Months

Interpretation and limitations

Surname3
The inflation rate is too low which means the consumers will have problems paying their
debt. The company will likely have problems with deflation and therefore a lower number of
customers who buy expensive goods. This indicates a low growth in the company. The standard
CPI set by the government is 2% +/-1 reduce the price pressure. When the inflation rate is 2%,
there is a normal period of economic growth. Buckle Company had a negative inflation rate in
September, October and November 2013 of -0.26,-0.2 and -0.01 respectively. This means that
the company went through immense pressure to recover. The overall economic recovery of
Buckle Inc. is very fragile due to an inflation rate of below 0.However there is optimism as
observed on the consumer sentiment index. The CS...

flag Report DMCA
Review

Anonymous
Thanks, good work

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors