solve engineering problem using analysis toolpak.

Criteria:Introduction of the problem statement and the presentation of the data. Apply appropriate statistical and probability methods in solving problems.

provide:Excellent tabulation and presentation of data which includes proper selection of key variables, arrangement and grouping of data. All the assumptions$/$values$/$refe rences and methods used are clearly defined. All the calculations and comparisons $($EXCEL and manual$)$ are presented in clear, precise, and correct manner. All the assumptions$/$values and methods used are clearly stated and explained, including the suggestion and conclusions.

Question $2$:

Inflation refers to the general increase of prices $($or conversely the general fall in the

purchasing value of money$)$ for goods and services in an economy. Inflation is normally

measured using a weighted average of prices for a 'market basket' of goods and services

purchased by consumers in a particular economy, known as the consumer price index

$($CPI$).$ Malaysia's CPI has $($in general$)$ steadily increased in the past decade, in line with

global trends. This is despite significant global and local factors wildly affecting other

economic measures such as currency exchange rate and GDP$.$

You and your group members need to collect data regarding CPI in Malaysia and compare

it with CPI data for a similar time period for two other countries $($one developing country

in the global south and one developed country in the global north$).$ You should examine

factors and variables which influence inflation and price of goods such as employment,

birth rates, GDP$,$ currency exchange rates, taxation rates and other related factors. Be sure

to specify your sources for all data used.

Show how you can apply the statistical toolpak and$/$or the probability toolpak in EXCEL

for data analysis and drawing meaningful conclusions regarding CPI in Malaysia and the

two countries being compared. You should also provide manual calculations verifying your

results from Excel. Based on your analysis, draw conclusions $($with justifications$)$ as to the

primary factors which affect inflation in Malaysia.