Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Description of the Problem, Sample and Population - Project 1 | DS 2334, Study Guides, Projects, Research of Business Statistics

Material Type: Project; Class: BUSINESS & ECONOMIC STATS II; Subject: DECISION SCIENCES; University: St. John's University-New York; Term: Unknown 1989;

Typology: Study Guides, Projects, Research

Pre 2010

Uploaded on 08/19/2009

koofers-user-q4y
koofers-user-q4y 🇺🇸

5

(1)

10 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Description of the Problem, Sample and Population
As an accounting major, I need to analyze a company’s financials in order to get a
good idea about its operations and financial position. A major part of a company’s
position involves its expenses, or what it’s spending money on. Equally important is a
company’s net income; this is a measure of how much money is being made or lost
during the year. A profit is either retained within the company for future use, distributed
to shareholders, or both. In my project, I want to investigate the relationship between two
of a company’s important figures. I’m investigating if a company’s net income has an
effect on its operating expenses.
In my project, the independent variable will be net income. An independent
variable is used to help make a prediction about the dependent variable. The dependent
variable is the variable you wish to predict. In my project, the dependent variable is
Selling, Administrative, and Operating Expenses, which includes a company’s major
expenses necessary for running the business.
I am expecting that β1 will be positive. I am expecting this because as my
independent variable, net income (X), increases, my dependent variable, Selling,
Administrative, and Operating Expenses (Y), will increase as well. This should result in
an upward sloping, or positive sloping line, which results in a positive linear relationship.
The population I am taking a sample from is publicly held companies classified in
the broad Retail industry. I took a random sample of twenty of these companies using
Hoover’s Online, a business database. I searched within each subdivision of the Retail
industry, and selected some of the top companies within that industry.
pf3
pf4
pf5

Partial preview of the text

Download Description of the Problem, Sample and Population - Project 1 | DS 2334 and more Study Guides, Projects, Research Business Statistics in PDF only on Docsity!

Description of the Problem, Sample and Population

As an accounting major, I need to analyze a company’s financials in order to get a

good idea about its operations and financial position. A major part of a company’s

position involves its expenses, or what it’s spending money on. Equally important is a

company’s net income; this is a measure of how much money is being made or lost

during the year. A profit is either retained within the company for future use, distributed

to shareholders, or both. In my project, I want to investigate the relationship between two

of a company’s important figures. I’m investigating if a company’s net income has an

effect on its operating expenses.

In my project, the independent variable will be net income. An independent

variable is used to help make a prediction about the dependent variable. The dependent

variable is the variable you wish to predict. In my project, the dependent variable is

Selling, Administrative, and Operating Expenses, which includes a company’s major

expenses necessary for running the business.

I am expecting that β 1 will be positive. I am expecting this because as my

independent variable, net income (X), increases, my dependent variable, Selling,

Administrative, and Operating Expenses (Y), will increase as well. This should result in

an upward sloping, or positive sloping line, which results in a positive linear relationship.

The population I am taking a sample from is publicly held companies classified in

the broad Retail industry. I took a random sample of twenty of these companies using

Hoover’s Online, a business database. I searched within each subdivision of the Retail

industry, and selected some of the top companies within that industry.

Data Collected

No. Selling, Administrative, and Operating Expenses (in millions) Y Net Income (in millions) X Company (Retail Industry) 1 $ 9,797 $ 3,198 Target 2 4,296 1,150 Gap Inc. 3 9,111 3,397 Sears Roebuck & Co 4 2,932 252 Toys R Us 5 1,162 588 Amazon.Com Inc 6 447 213 American Eagle Outfitters 7 689 389 Coach Inc 8 6,080 919 CVS Corporation 9 1,393 505 Bed Bath and Beyond 10 898 202 Michael's Stores, Inc 11 7,562 2,176 Lowe's Companies 12 5,053 984 Best Buy 13 936 304 Tiffany & Co 14 5,044 1,063 Costco Wholesale Corp 15 2,960 708 Staples 16 1,052 143 Barnes & Noble 17 4,933 689 Federated Department Stores 18 5,827 524 J.C. Pennys 19 184 84 Aeropostale 20 2,351 705 Limited Brands

Source: Hoover’s Online (www.hoovers.com)

Interpretation of b 1 and b 0

In interpreting b1, one can conclude that for every additional million dollars of net income

a company has, their selling, administrative, and operating expenses will increase by 2.

million dollars.

By interpreting b 0 in this situation, one can conclude that when a company’s net income

is 0, their selling, administrative, and operating expenses will be 1130 million dollars.

Test for Significance

H 0 : β 1 =0 (Net income has no effect on S, A, &O Expenses)

H 1 : β 1 ≠0 (Net income has an effect on S, A, &O Expenses)

Predictor Coef SE Coef T P Constant 1130.0 452.7 2.50 0. Net Income (in millions) X 2.7542 0.3496 7.88 0.

At = 0.05, the tTABLE value will be ±2.1009. The tCALC value, as per the above table, is

Since tCALC = 7.88 is greater than tTABLE = 2.1009, we reject H 0. By rejecting H 0 , we can

conclude that net income, the independent variable, has an effect on Selling,

Administrative, and Operating Expenses, the dependent variable.

P-Value

S = 1440.72 R-Sq = 77.5% R-Sq(adj) = 76.3% Analysis of Variance Source DF SS MS F P Regression 1 128856671 128856671 62.08 0. Residual Error 18 37362197 2075678 Total 19 166218869

As per the computer output, the p-value for this situation is 0.000.

We are using a level of significance of  = 0.05 in this problem. The stated level of

significance  = 0.05 is > p-value = 0.000. When the level of significance is greater than

the p-value, we reject H 0. Therefore, we reject the null hypothesis, and using the p-value,

we can conclude that net income has an effect on Selling, Administrative, and Operating

Expenses.

Confidence Interval

The formula to determine confidence interval for the value of β 1 is: b 1 ± tTABLE (Sb1)

Therefore, the calculation for a 95% confidence interval in this situation would be:

The confidence interval would be (2.016 < β 1 < 3.484)

This interval means that we are 95% certain that the slope of the regression line in this

problem will lie between 2.016 and 3.484.

Consistency

In Part 5 and 6, I used hypothesis testing and the p-value to determine whether or not net

income had an effect on S, A, & O Expenses. In my test, I was trying to determine

whether or not β 1 was equal to zero. In both these parts, I determined that β 1 was not

equal to zero, and as a result, I concluded that net income had an effect on Selling,

Administrative, and Operating Expenses. My answer in Part 7 is consistent with this

conclusion. In part 7, I estimated a range for the value of β1. My results gave me a range

of β 1 being between 2.016 and 3.484. This is consistent in stating that β1, or the slope is

not equal to zero. Therefore, all three parts are consistent in saying that net income has an

effect on Selling, Administrative, and Operating Expenses because the slope of β 1 is not

equal to 0

Coefficient of Determination

The computer output for the coefficient of determination, or r^2 , is 77.5%. We can

interpret this to mean that 77.5% of variation in Selling, Administrative, and Operating

Expenses are a result of the net income.

Stefanie Schumacher

DS 2334- Statistics II

MWF 8:00-8:55 AM

Professor Shiro Withanachchi

Project 1- Simple Regression Model

Analysis of the Effect a Company’s Net Income has on it Selling, Administrative, and

Operating Expenses