Purchase Solution

Forecast, Determining Index & Plot Graph

Not what you're looking for?

Ask Custom Question

A manufacturer of grinding tools is concerned about the durability of its products which depends on the permeability of the sinter mixtures used in production. Suspecting that carbon might be the problem, the plant manager collected the following data.

WK 1 WK 2 WK 3 WK 4 WK 5 WK 6 WK 7 WK 8 WK 9
Carbon Content 5.5 3 4.5 4.8 4.2 4.7 5.1 4.4 3.6
Permeability Index 16 31 21 19 16 23 20 11 20

a. Develop chart and determine the Index for week 10. Draw a Scatter plot of the data.
b. Is there a relationship between permeability and carbon content?

Purchase this Solution
Solution Summary

Excel spreadsheet shows how to chart and determine an index, with a scatter plot and find relation between.

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

View More Free Quizzes
Related BrainMass Solutions

  • Market Efficiency

    Analysts had forecast quarterly earnings of $0.90/share (the analyst forecast is the average of forecasts by 19 analysts).

  • Demand forecasting for management policy decision.

    So this is the forecast of deseasonalized demand. In order to "re-seasonalize" the data, we simply multiply each forecast by the corresponding seasonal index. In the following page you can find a graph of the actual forecasts.

  • Investment Problem/Graph

    Use this data to calculate a market weighted index and plot the value of this index on the same graph as the price weighted index. Assign a starting index value of 100. f.

  • Plotting Data

    Plot your forecast on the same graph as the original data. c.) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year.

  • Plotting and Trends

    b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data.

  • Capital Budgeting: Net present value, IRR, discount profile

    What is this discount rate at which the graph intersects the horizontal axis? What does the graph 'show? c. A project requiring a $3.2 million investment has a profitability index of 0.97. What is its net present value?

  • Forecasting the demand by moving average method

    Above graph compares actual demand and forecast of demand by using 3-period moving average and 5-period moving average methods. We find that plot of 3 period moving average forecast is smoother than the plot of actual demand.

  • Construct a Time Series Plot for the Commodity Futures Index

    513932 Construct a Time Series Plot for the Commodity Futures Index Ten weeks of data on the Commodity Futures Index are 7.35, 7.40, 7.55, 7.56, 7.60, 7.52, 7.52, 7.70, 7.62, and 7.55. a. Construct a time series plot.

  • Time series forecasting problem

    What are the forecast values for months 13,14, and 15? Period Unseasonalized forecast Seasonal index Seasonalized forecast 13 4066.588 0.929 3776.871 14 4098.273 0.928 3804.561 15 4129.959 1.161 4796.312 5.

View More Related Solutions