Reference no: EM131921958
Assignment
Download "Population Historical" data from the government website.
• Select the data for each continent and their populations and group together at the top of the spreadsheet. Use only population data from the last 10 years.
• Create an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. (1 hour for a, b, c).
Create narratives based on the Excel Area Chartto discuss the following in a minimum of 1,200 words:
• Interpret the historical trend in increase/decrease of population per continent.
• Formulate a prediction on how the population would vary in the next decade. How did you arrive at this conclusion?
• Investigate how Excel creates a forecast. Explain the steps involved.
• Convert your area chart into a line chart in Excel, and add forecasted values. Include a screenshot in your paper.
• Compare the forecasted output that Excel has provided with the conclusions you have arrived at in regards to the trend in the increase/decrease of population.
• Recommend other Excel data analysis properties or chart types that could be used to demonstrate your data findings.
|
Define the divergence and control reversal speeds
: Given a flexible wing. Define the divergence and control reversal speeds. Are these related to each other? Equations are not necessary, but may be used
|
|
How does a prestige pricing policy fit into a marketing mix
: How does a prestige pricing policy fit into a marketing mix? Would exclusive distribution be necessary? Cite a local example of odd-even pricing and evaluate.
|
|
Estimate possible sales quantities and the program
: Break-Even/Profit Analysis This problem lets you see the dynamics of break-even analysis. The starring values (costs, revenues, etc.) for this problem arc.
|
|
Simulate five days of operation of the proposed systems
: Develop a spreadsheet simulation to compare the performance of the proposed automated process with the performance of the manual existing process
|
|
Create narratives based on the excel area chartto discuss
: Create narratives based on the Excel Area Chartto discuss the interpret the historical trend in increase/decrease of population per continent.
|
|
What is the takt time of the process
: A process makes two products, A and B, and operates 5 days per week, 8 hours per day. demand for the two prducts for the next week is as follows.
|
|
Identify the strategy decisions marketing manager must make
: Identify the strategy decisions a marketing man-ager must make in the Price area. Illustrate your answer for a local retailer.
|
|
Explain carefully what the p-value represents in context
: Is this hypothesis test a right-tailed , left-tailed, or two-tailed test? Explain why you chose that kind of test in this situation.
|
|
Determine the profit and the breakeven quantity per year
: A product is currently made in a product-focused shop, where fixed costs are $10,000 per month and variable cost is $60 per unit.
|