Statistical packages-linear regressions

Reference no: EM1313243

The intent of this week exercise is to familiarize with EXCEL and to gain experience and practice in interpreting the output generated by most statistical packages (EXCEL) when linear regressions are run on a set of data.

The following data shows total sales volume for organic milk, price per gallon, and average household income.

Year	Qd (sales in million gallon)	Price per gallon ($)	Household income ($)
1999	1200	4	35,000
2000	1300	3.9	36000
2001	1320	4	37000
2002	1340	3	38000
2003	1310	3	34000
2004	1400	2.6	40000
2005	1390	2.5	40000
2006	1420	2	42000
2007	1410	2	40000
2008	1430	1.8	48000

Use Microsoft Excel to run a regression analysis for the following data. In Excel, first you need to type above data into your Excel spreadsheet. Then go to "tools", to "Data Analysis", to "Regression." Input sales data into"Input Y range" and price and income data into "Input X range." Mark "output range" and specify a worksheet location you want to place the output.

Reference no: EM1313243

Questions Cloud

The equivalent certain income to this bet : Robert Nozick concluded which no state should provide any services beyond law enforcement.Illustrate what is the equivalent certain income to this bet.

Contraction of heart muscle : A rapid beat of heart over 100 beats per minute is known as ______. A beat slower than 60 is called ______. Lack of appropriate blood to the heart is known as ______. Rapid shuddering of the heart muscle is called ______.

Determine the extra work required to stretch : Many communications satellites orbit the earth in geostationary orbits. (They appear to remain in the same positions in the sky for observers on the earth's surface.) If such a satellite orbits at a height of 40,000 km, estimation the time delay in a..

Appropriate monetary policy which the bank of canada : State the appropriate monetary policy which the Bank of Canada should be operating, given the above situation.

Statistical packages-linear regressions : The intent of this week exercise is to familiarize with EXCEL and to gain experience and practice in interpreting the output generated by most statistical packages (EXCEL) when linear regressions are run on a set of data.

Computation of par value of stock after split off : How much of the $1,000,000 notes payable should be classified as current in Reeds balance sheet at December, 2007 and Computation of par value of stock after split off

Determining cost of equity as well as weighted average cost : Determining cost of equity as well as weighted average cost of capital and What would be the impact on its feasible project set

Key things which make your matter interesting : Describe your matter, with a brief summary of the key things which make your matter interesting. Illustrate what are the key positive also normative questions surrounding your matter.

Find the coefficients of static and kinetic friction : A simple pendulum in a science museum entry hall is 3.51m long, has a 1.25kg bob at its lower end, and swings with an amplitude of 10.50 degrees. How much time does the pendulum take to swing from its extreme right side to its acute left side.

User Account

All Pages