MAT225 Excel Project

MAT225 Excel Project

Take Home Problems

Please, use Excel to do the scatter plot, print out the graph, generate the models, and handwrite all your answers with detail in Excel spreadsheet for this assignment. Type your name with the date of completion on your Excel worksheet. Please, make sure to complete this assignment by doing the work on your own. Do not copy someone else’s work or print out the Excel graphs from another classmate’s file. You will receive a zero when plagiarize the work.

I. You select a NFLsport franchise, Tampa Bay Buccaneers and want to analyze the revenue, cost, and profit of this business. You research and collect 6 years data (2009-2014) from the financial reports of Tampa Bay Buccaneers from Forbes website. Analyze the data with the use of Excel.

1.       Use Excel to draw a scatter plot with years vs. revenue and find the revenue model (use polynomial function with degree of 3).

2.       Use Excel to draw a scatter plot with years vs.total costs.Find the cost model (use linear function with degree of 1).

3.       Use the model that you have developed to estimate the exact rate of change forrevenue for the year 2015.

4.       Use the model that you have developed to estimate the exact rate of change on the costfor the year 2015.

5.       Find the profit function P(x) by using the results and estimate the profit for 2015.

II. The business of manufacturing and selling tennis racquets is one of frequent changes. Companies introduce new models to the market as innovations and advances in technology lead to improvements in racquets. Many factors contribute to a company’s decision-making processes when deciding how to best use advertising dollars. One of the factors is to track the sales in relation to the amount spent on advertising. Suppose that a company has the following data from the past sales.

1.       Use Excel to generate a scatter plot and find quadratic function that best fit the data.

2.       Determine the domain and range of the function.

3.       Based on the quadratic equation from (2), differentiate the model and find its critical value.

4.       Approximate how much the company should spend on advertising the next

new model in order to sell the maximum number of tennis racquets?

5.    Find the exact rate of change when 170 (thousands) spent on advertising.

III. In your sociology class, you have been asked to research the decline of Detroit (the great motor city). There are many reasons contributing to the demise and decline of Detroit. You focus your study on its population. Based on the data you gather, you hope to draw some meaningful conclusion with prediction for the future of this City.

Detroit population from 1900 to 2010 as follow:

1.       Use Excel to draw a scatter plot with data from 1900-2000. Input the years since 1900 as 0 and their populations. (Note: the interval for the input of Year is 10 year apart) Develop a polynomial model with degree of 2 to estimate the total population for the year of 2010.

2.       You observe the decline of Detroit population started sometime during the 1950. Use Excel to draw a scatter plot (use data 1950-2000) with years since 1950 as 50 and their populations in thousands. Develop a logistic model and estimate the population for the year of 2010. (input x=110 for year 2010 to estimate y value)

3.       Use the data 1950-2000 and develop an exponential model to estimate the total population for the year of 2010.

4.       Compare your estimate of 2010 population based on the above 3 models (part 1, 2, and 3) and make comments on the differences you found when compare them to the actual census figure of 714 thousands in population. Which model provides us with a more accurate estimation?

5.       If the trend continues, what can we expect the population of Detroit in the year of 2015? (Use the 3 different models to estimate)

IV. The data below show the average growth rates of some genetic engineering oak trees in Florida.

1.       Use Excel to draw a scatter plot and determine a logarithmic model/equation.

2.       Use the above model to find the average height of the trees at 5.5 years of age?

3.       Use the logarithmic model to predict the average height of the trees at 14 years of age?

4.       Find the exact rate of change when the age of the tree is 5.5 years of age?

5.       If the average height of the trees is 23 feet, what is the age of the trees?

V. The annual salaries of FL members of Congress have been increased exponentially. Data in the table shows the salaries for year after 2000.

1.       Use Excel to draw a scatter plot and build an exponential model from the data.

2.       Use the exponential model to estimate the annual salaries for members of congress in 2015.

3.       After what amount of time will the annual salary be $240,000?

4.       What is the rate of change in 2015?

5.      What is the doubling time for the salary of member of congress since 2000?