Reference no: EM132754908

ALL QUESTIONS ARE COMPULSORY.

Question 1. City Power & Light produces voltage-regulating equipment in New York and ships the equipment to Chicago. The voltage held by each unit is measured in New York before shipping and is measured again when the unit arrives in Chicago. The file citypower.xls contains the measurements. Find
a. What is the maximum and the minimum % voltage drop?
b. Find the central tendencies of % voltage drop.
c. Is the % voltage drop symmetric? Give reasons.
d. Is there any relationship between the initial voltage and the voltage drop? If yes, what kind of relation is it?
e. The equipment must be rejected if there is more than 50% voltage drop. Count the numbers of equipment that can be accepted.

Question 2. Find below the revenues for CISCO in millions of USD of the years 2009 - 2018:

Establish the best fit regression equation for predicting CISCO's revenue in future (You have to list the equations and the R2 values of all the possible fits and justify which one is the best fit equation). What is CISCO's expected revenue in 2019?
(show your work in a new workbook, name it as CISCO.xls)

Question 3. In cardata.xls, you will find information for 392 different car models. Based on the data establish a multiple linear regression equation to predict the MPG for a car. How good is the prediction? Are all the independent variables significant? Give reasons. 5

Question 4. In fastfood.xls you will find the total revenues (in millions USD) for a fast-food store over the 11-year period from 2005 to 2015.
a. Plot 5 yearly moving average plots against the original time-series plot.
b. Find the linear trend with 5 yearly moving averages.

Question 5. In index2.xls you will find the per unit selling prices and numbers of units sold for 5 commodities in 2010 and 2015.
a. Find all Indices.
b. Perform TRT&FRT and explain which indices qualify for becoming ‘ideal'.

Question 6. In mortality.xls the population and the number of deaths are given for a district for different age groups for a particular year. Calculate
a. Crude Death Rate
b. Age-specific Death Rates
c. Explain the difference between Crude Death Rate and Standardized Death Rate.

Question 7. A machine is set to deliver packets of a given weight. 10 samples of size 6 each were recorded in SQC2.xls.
a. Calculate the values for the central line and the control limits for mean chart and the range chart (Conversion factors for n = 6 are A2 = 0.48, D3 = 0 and D4 = 2)
b. Draw the control charts and comment on the state of control based on the control charts.