Since the computer hard drive was invented in 1956, a con- stantly increasing data storage capacity has been available at an ever-decreasing cost. Use the historical data of hard drive capacities and prices shown in Figure 3-29 (or download the Excel file named CH03Ex01). Modify the spreadsheet so that it includes a new column containing formulas that calculate a common measure of disk size (GB) and a second new column that computes the cost per GB for each year. (Recall 1 gigabyte = 1,024 megabytes; 1 terabyte = 1,024 gigabytes.) Now, create one line graph to show the cost per gigabyte from the period 1995 to 2016. Create a second line graph to show changes in the size of hard disks across the same period. (Tip: Use the “Hide” function to cover the columns you don’t need for each graph.) Write a brief summary of the trends you found. What factors have contributed to these trends? What are the implications of these trends? 1980 26 MB $5,000 1981 63 MB $2,895 1983 20 MB $3,495 1984 20 MB $2,399 1987 40 MB $1,799 1989 20 MB $899 1995 1.7 GB $1,499 1996 3.2 GB $469 1997 7.0 GB $670 1998 8.4 GB $382 1999 19.2 GB $512 2000 27.3 GB $375 2001 40 GB $238 2002 100 GB $230 2003 120 GB $168 2004 250 GB $250 2006 390 GB $106 2008 1 TB $200 2010 1.5 TB $220

Bank Of England Rate Cut

On Thursday, Aug 4, 2016 the Bank of England cut its interest rate to 0.25% -- the lowest it’s ever been in the central bank’s 332-year history. They also announced the government would buy government and corporate bonds (quantitative easing). Check out this article in The Guardian. This is all in response to changes in the economy since the UK voted to leave the European Union in June. What is the central bank trying to do – increase the money supply or decrease the money supply? Why? How would that help the economy? Will it work?

Ethel

Business Ethics UK law

Raj is a human resources manager of a company that is trying to control its costs. The company pays the healthcare costs of its workers and these costs have been rising. The total cost for healthcare can be lowered if the employees eat better quality food and avoid poor quality food. Raj wants to institute a program where employees report to him their monthly diet so that he can recommend changes which will lower the company’s healthcare costs and potentially improve the employee’s health. Should Raj initiate this program?

(a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.)

(b) Use each of the three fitted trend equations to make numerical forecasts for the next 3 years. (Round the intermediate calculations to 2 decimal places and round your final answers to 1 decimal place.)

I am having issue predicting the future trendlines.I got 11407.7, 12433.4, and 13551.4 and these were incorrect. Can you please help me learn what I am doing wrong.

1. Use the data below to find the linear regression equation that best represents the given data and predict the revenue in 2013 (Copy data to Excel)

2. Then create Two new columns that represent the predication y =mx+b for each year and percent of growth for each year = (Revenue/Predication)*100

3. Use Excel to graph the linear model (x-axis years, y-axis revenue) and the linear equation of best fit.

1. Fill out the missing entry for prediction and percent of growth
2. Find the value of the linear correlation coefficient r.
3. Find the equation of the regression line, letting Number of years be the independent (x) variable.
4. Find the coefficient of determination.
5. Find the standard error of estimate s_e.

A) What is the cyclical deficit, and when is it appropriate to have such a deficit? Why?

B) How do automatic stabilizers, on both the expenditure and revenue sides of the budget, respond during a recession?

C) Use the table below to answer the following questions. The federal deficit fell from $1,300 billion in 2011 to $680 billion in 2013. How much of this change was due to the growing economy? How much of this change was the result of fiscal restraint ?

Grouse in Russia show a recessive mutation “short-tail” that causes problems in the control of direction when flying. In 2002 a survey of a large, freely interbreeding, population of 1,856 grouse revealed 142 with short tail feathers.

a) What proportion of the grouse population would you expect to be heterozygous at the short-tail locus

b) What proportion of the grouse population would you expect to be heterozygous at the short-tail locus

c) Due to rising affluence there was an increase in recreational grouse hunting. In a later survey of the grouse over some years it was found that a significant decrease had taken place in the population. In 2003 there were 2,861 grouse and in 2004 there were only 2,369 and all the surviving grouse had long tails. Support by calculation that this change would reflect greater vulnerability of short tail grouse to killing by hunters.

d)After further random mating of survivors what would be the percentage of homozygous dominants, heterozygotes and homozygous recessives expected in the next generation in the absence of any further hunting?

• Use Excel to conduct a regression of the values of the security against the predictors and verify the validity of underlying assumptions
  • Check for homoscedasticity and serial correlation
  • If necessary, rerun the regression using robust standard errors
  • Look for evidence of multicollinearity and eliminate redundant predictors if necessary

The worksheet "grocery" of "Assignment #4-2 (DATA)" gives the median store size (in square feet) by year for grocery stores. Note that this file is the same as the one given in Question 1.

Step 1: Run the simple linear regression and find the slope of the sample regression equation. Give your answer to 4 decimal places.

Answer- .6783

Step 2- According to the sample regression line, a point estimate for the median grocery store size in 2012 is: (Give your answer to 1 decimal place.)

Answer- 49.9

Step 3- The standard error of fit is approximately?? (Give your answer to 3 decimal places.)