Basic Computational Techniques For Data Analysis An Exploration In MS Excel 2nd Edition D Narayana, Sharad Ranjan, Nupur Tyagi - Solutions

Discover the ultimate resource for mastering "Basic Computational Techniques For Data Analysis An Exploration In MS Excel 2nd Edition" by D Narayana, Sharad Ranjan, and Nupur Tyagi. Access comprehensive online answers key, detailed solutions manual, and solutions PDF that cover all solved problems. Explore our extensive collection of questions and answers, including a test bank and chapter solutions designed to enhance your learning. Benefit from step-by-step answers and the instructor manual, tailored to provide a deep understanding of this textbook. Enjoy the convenience of a free download to support your educational journey.

Since the Navy wishes to use a regression model based on efficiently run hospitals, it follows that hospital 14 be removed from the data set if it is concluded that hospital 14 was inefficiently run. Using the results from fitting model defined in Exercise 4.9 to the data set modified by removing
The main objective of this regression analysis is to help the Navy evaluate the performance of its hospitals in terms of how many labor hours are used relative to how many labor hours are needed. The Navy selected hospitals 1 through 17 from hospitals that it thought were efficiently run and wishes
Consider relating y (HOURS) to x1 (XRAY), x2 (BEDDAYS), and x3(LENGTH) by using the model y = β0 + β1x1 + β2x2 + β3x3 +Plot y versus each of x1, x2, and x3. Do the plots indicate that the above model might appropriately relate y to x1, x2, and x3? Explain your answer. You may compute other
A laundry detergent manufacturer wished to test a new product prior to market release. One area of concern was the relationship between the height of the detergent suds in a washing machine to the amount of detergent added and the degree of agitation in the wash cycle. For a standard-size washing
The data in the following table (Kutner et al. 2005) are from a study relating the amount of body fat (y) to several possible predictor variables:triceps skinfold thickness (x1), thigh circumference (x2), and midarm circumference (x3), measured on a random sample of healthy females 25–34 years
In an experiment to study the problem of predicting the tensile strength(y) of concrete beams from measurements of their specific gravity (x1)and moisture content (x2), a multiple regression was fitted to data for 10 specimens (Devore 1982). The data are given as follows:
Thirteen specimens of Cu–Ni alloys with varying degrees of iron content in percent were submerged in sea water for 60 days and the weight loss due to corrosion recorded in units of milligrams per square decimeter per day. In a study to examine the dependency of corrosion (y) on iron content (x),
Experience with a certain type of plastic indicates that a relation exists between the hardness (measured in Brinell units) of items molded from the plastic (y) and the elapsed time since termination of the molding process (x). In a study to examine this relationship, 16 batches of the plastic were
To model the relationship between the dose level of a drug product and its potency, a pharmaceutical firm inoculated each of 15 test tubes were with a virus culture and incubated for 5 days at 30 ◦C. Three test tubes were randomly assigned to each of the five dose levels to be investigated(2, 4,
A realtor studied the relationship between x = annual income (in 1000’s of dollars) of home purchasers and y = sale price of the house (in 1000’s of dollars). The realtor gathered the data from mortgage applications for 24 recent sales in the realtor’s sales area in one season (text file
It is reasonable to expect that more miles an automobile has been driven, the higher will be the levels of pollutants it emits. The following data give hydrocarbon (HC) emissions (y) at idling speed, in parts per million(ppm), and the distances traveled by each automobile in thousands of miles (x).
Athletes are constantly seeking measures of the degree of their cardiovascular fitness prior to a major race, because they want to ensure that they are training at a level which will produce peak performance. One such measure of fitness is the time to exhaustion from running on a treadmill at a
The text McClave et al. (2000) discusses the following problem that relates the value of a home to its upkeep expenditure.Quality Home Improvement Center (QHIC) operates five stores in a large metropolitan area. The marketing department at QHIC wishes to study the relationship between x, home value
The following data are from an experiment that tested the performance of an industrial engine (Schlotzhauer and Littell 1997). The experiment used a mixture of diesel fuel and gas from distilling organic materials.Write and execute a SAS program to perform the computations to provide answers to the
Obtain a histogram of the Nox variable from the pollution data set (see Tables B.7). Examining the output from proc univariate for this variable, it is observed that Nox values are highly dispersed. So it is necessary to use unevenly spaced intervals to obtain a useful bar chart for this variable.
The data set available in the Excel file heart.xlsx is a selected subset of the SASHELP SAS data file heart containing data from the Framingham Heart Study. The variables of interest are AgeAtDeath (a numeric variable), DeathCause, and Sex which are character variables. Import the data using proc
Use the the world SAS data set created in Exercise 2.14 for this problem as in the above problem. In order to study the effects of urbanization on crude death and birth rates, obtain side-by-side scatter plots of these variables against urban population variable. Identify the points by grouping
For this problem assume that the world SAS data set created in Exercise 2.14 is available (otherwise, you may create this data set by executing SAS code as described in that exercise). Write five proc steps using statistical graphics (sg) procedures in the same SAS program (or separate SAS
Use the world SAS data set and proc sgplot to obtain horizontal bar charts showing the means of the per capita GNP variable for each of the two groups of countries with level of technology defined by the Techgrp variable. Subdivide each bar into the three groups, defined by the Infgrp variable. Use
Obtain a normal probability plot of the Popurban variable and a histogram of the the Deathrat variable in the demographic data set on countries (see Table B.5) used in SAS Example C12. Use proc univariate, as was done in the SAS Example C13 program. Use the normal option to add a reference line to
Use the fitness data set (see Table B.4) and proc sgplot to obtain horizontal bar charts showing the means of the Aero variable for each of the three groups of people with oxygen uptake rates(10.5), defined as a user-defined format for Oxygen variable. Subdivide each bar into the three 1.5-mile
Use the fitness data set (see Table B.4) and proc sgpanel to obtain vertical bar charts showing the means of the BMI variable for each of the three age groups defined by the AgeGrp variable. Obtain this plot in three panels, each panel corresponding to a level of the WtGrp variable. Make sure that
Insulin production from beta islets (insulin-producing cells) in the pancreas of obese rats, reported in Koopmans (1987), are reproduced below. In addition to measurements made at end of each of the first 3 weeks, data are also available for the first day of the experiment (labeled Week 0):a.
Rice (1987) cites an experiment that was performed to determine whether two forms of iron (Fe2+ and Fe3+) are retained differently. The investigators divided 108 mice randomly into 6 groups of 18 each; 3 groups were given Fe2+ in 3 different concentrations, 10.2, 1.2, and 0.3 millimolar, and 3
Groundwater quality is affected by the geological formations in which it is found. A study of chlorine concentration was carried out to determine whether differences in quality existed for water tables on the east and west sides of the Rio Grande River in New Mexico. The data from wells on each
Carry out an analysis similar to SAS Example C3 for the Weight variable in the biology data set using proc univariate in a SAS program. Obtain a histogram using midpoints that you select and an overlaid normal curve fitted to the data. Also use an ODS SELECT statement to create tables and graphics
Write a SAS program to use the data set (named world2) saved in Exercise 2.16, in a proc tabulate step to print a tabulation giving the sample size, sample mean, sample standard deviation, and the standard error of the mean of the variables popurban for subgroups of observations defined by the
In a new SAS program, use the SAS data set world2 saved in Exercise 2.16 in a proc freq step to do the following:a. Obtain two-way frequency tables (in the cross-tabulation format)for the variable Techgrp with Infgrp, Techgrp with Civilgrp, and Popgrp with Infgrp. Compute chi-square statistics,
Add a proc means step containing appropriate class and output statements, to the same SAS program used in Exercise 2.17, to create a SAS data set named stats1. The data set stats1 must contain sample means, standard errors of the means, and maximum and minimum values of the variables Birthrat,
In a new SAS program, use the SAS data set world2 saved in Exercise 2.16 in a proc univariate step to compute descriptive statistics, extreme values, percentiles, and low-resolution plots for the variables Lifeexp, Percgnp, and Popurban. Use an appropriate option to calculate t-tests for the
Use the printed output from the analysis performed in Exercise 2.15 to determine good cutoff values for creating additional category variables Birthgrp, Deathgrp, and Popgrp (each with three categories)corresponding to these variables. In a data step of a new SAS program, access the SAS data set
In a SAS program, use proc univariate to compute 33.3 and 66.7 percentiles of the variables Birthrat, Deathrat, and Popurban available in the SAS data set world. Access the SAS data set saved previously in Exercise 2.14. Use the output statement to save these statistics in a temporary SAS data set
Write a SAS program to create a SAS data set named world using the data in Table B.5. Label variables as appropriate. Create category variables as described below:Variable Groupings Category variable Infmort< 24 = 1 (low)24–73 = 2 (moderate)≥ 74 = 3 (high)Infgrp Levtech < 24 = 1 (low)≥ 24 = 2
Add a proc means step containing appropriate class and output statements, to the same SAS program created in Exercise 2.12, to create a SAS data set named stats1. The data set mystats must contain sample means and standard errors of the means of the variables BMI, RunTime, and Oxygen for each of
Those participants of the physical fitness program discussed in Exercise 2.11 with BMI exceeding 25 or BurnRate less than 15 were selected for an advanced aerobics program. Add a proc print step to the SAS program in Exercise 2.11 to obtain a SAS listing (i.e., a SAS report)that contains only the
The data for this problem consist of measurements made on a group of people participating in a physical fitness program. The name of the file is fitness.txt and is described in Table B.4 of Appendix B. Use the following input statement to read these data:input Id 2. WtLoss 2.1 Height 2. Weight 3.
Write a SAS program containing an infile statement to access the data set used in SAS Example B5 (see Fig. 2.13) from a text file. Use proc tabulate to obtain a table laid out as follows. The rows of the table consist of the combinations of year in school and gender, with the levels of gender
An example in Schlotzhauer and Littell (1997) presented data from an experiment conducted by an epidemiologist who classified the disease severity of dairy cows (none, low, high) by analyzing blood samples for the presence of a bacterial disease. The size of the herd that each cow belonged to was
In a study of the relationship between hair color and eye color among 592 students in a statistics course, the following data were obtained. Use the data to compute a chi-square test of independence using proc freq.Use nominal measures of association, the contingency coefficient C and Cramer’s V,
The following data, taken from Rice (1987), represent the incidence of tuberculosis in relation to blood groups in a sample of Eskimos. Is there any association of the disease and blood group?Severity O A AB B Moderate-advanced 7 5 3 13 Minimal 27 32 8 18 Not present 55 50 7 24 Write a SAS program
The number of noxious weeds found in 1/4 ounce samples of Phleum pratense (meadow grass) is recorded below, where xi denotes the number of noxious weeds and ni denotes the number of samples with xi noxious weeds out of a total of 98 samples:xi 0 1 2 3 4567 ≥ 8 ni 3 17 26 16 18 9 3 5 1 Write a SAS
Devore (1982) discussed an example in which it is examined whether the phenotypes produced from a dihybrid cross of tall cut-leaf tomatoes with dwarf potato-leaf tomatoes obey the Mendelian laws of inheritance.There are four categories corresponding to the four possible phenotypes, tall cut-leaf,
A political organization in a certain state, interested in making sure that they reach persons of every racial category in their advertising, obtains a random sample of 200 from their lists. The following counts are obtained from the sample using the available demographic information:Race White
Ott and Longnecker (2001) present an example in which the number of cell clumps per algae species was fitted to a Poisson distribution. A lake sample was analyzed to determine the number of clumps of cells per microscope field. The data are summarized below for 150 fields examined.Here, xi denotes
Organizations interested in making sure that accused persons have a trial of their peers often compare the distributions of jurors by age, education, and other socioeconomic variables. One such study provided the following information on the education of 1000 jurors:Education Elementary Secondary
The following SAS program inputs information about hospitals in cities in different states, such as the size of the state and the cities (i.e., population), median income and median housing costs, the number of admissions, and the number of beds, using three different data types 1, 2, and 3. Answer
A local high school collects data on student performance in grades 9 through 12. In grades 9 and 10, data were collected for Science and English only, while for grades 11 and 12, Math scores were also recorded.Unfortunately, the data so collected were recorded as described below resulting in two
Ms. Anderson wants to use a SAS program to compute the total score, assign letter grades, and compute summary statistics for her college Stat 101 class. A maximum of 50 points each could be earned for the quizzes, 100 points each for the midterm exams and the labs, and 200 points for the final
The admissions office of a college has collected data on prospective undergraduate students. A subset of the data is given blow. We will construct a single SAS program to do the tasks outlined in the steps below:High school College entrance Id Age Gender GPA Exam score 2101 18 M 3.7 650 2102 18 F
A research project at a college department has collected data on athletes.A subset of the data is given below. We will construct a single SAS program to do the tasks described in the itemized parts below.Systolic Diastolic blood blood Heart IdNo Age Race pressure pressure rate 4101 18 W 130 80 60
You have five plots randomly assigned to fertilizer A and five to fertilizer B a yield variable is measured on each plot. One would, for example, like to structure the SAS data set to look as the following:Fert Yield A 67 A 66 A 64 A 62 A 68 B 70 B 74 B 78 B 77 B 80a. Write an input statement to
Study the following program:data tests;input Name $ Score1 Score2 Score3 Team $ ;datalines;Peter 12 42 86 red Michael 14 29 72 blue Susan 15 27 94 green;run;proc print; run;a. Sketch the printed output produced from executing this program.b. What would be the printed output if the input statement
Consider the following SAS data step:data result;input Type C1 C2 ;datalines;502 731.00;proc print;Display appearance of the output from the print if each of the following sets of statements, respectively, appeared between input and datalines; when the program is executed:a. Index = (2*C1) + C2;b.
Write a SAS data step to create a data set named corn with variables Variety and Yield using input data lines entered with varying numbers of pairs of values for the two variables as shown in the following:A 24.2 B 31.5 B 32.0 C 43.9 C 45.2 A 21.8 B 36.1 A 27.2 C 34.6
Sketch the printed output produced by executing the following SAS program. Display the contents of the program data vector immediately after processing the first line of data (just before it is written to the SAS data set).data compete;input Red Blue Grey Green White;array grade8(5) Red Blue Grey
Display the printed output produced from executing the following SAS program. Show what is in the program data vector immediately after processing the first line of data.data carmart;input Dept $ Id $ P82 P83 P84;Drop P82 P83 P84;Year=1982; Sales=P82; output;Year=1983; Sales=P83; output;Year=1984;
Display the printed output produced by executing the following SAS program. Show what is in the program data vector at the point the first observation is to be written to the SAS data set.data b21;input Y1 Y2 @@;Y3=Y2**2-5.0;Y4=sqrt(Y1)/2+1;drop Y1 Y2;datalines;4 -3 0 2 9 . 16 5 1 12;proc print
Show the values for the variable Miles that will be stored in the SAS data set distance:data distance;input Miles 5.2;datalines;1 12 123 1234 12345 1.12.12.3 1234.5;
The program data vector in a SAS data step has variables with values as follows:Code = ‘VLC’Size = ‘M’V1 = 2 V2 = 3 V3 = 7 V4 = .Determine the results of the following SAS expressions:a. (V1 + V2 - V3)/3b. V3 - V2/V1c. V1*V2 - V3d. V2*V3/V1e. V1**2 + V2**2f. Code = ‘VLC’g. Code =
The following data lines are input in a data step:21 50.2 17 47.5 54 32.1 12. 54.3 23.45.6 What would be the contents of the SAS data set if the input statement used was each of the following? Write a brief explanation of what takes place in each data step.a. input Id Score1;b. input Id Score1
Sketch the output resulting from executing the following SAS program.Describe in your own words the flow of operations in the data step in creating this data set.data two;input Score @@;if Score > 70 then do;Adjust = "y";Index = Score -70;end;else if Score < 70 then do;Adjust = "n";end;datalines;67
Each of the following cases shows the observations written to the SAS data set (variable names and corresponding data values) when the given lines of data are read by the given INPUT statement:a. input Id Gender $ Age GPA SAT;1906F193.25725 2045M.2.95690 3117M243.72793b. input (Q1-Q4)
Complete the following table for a loan of ₹80,000 that is repaid with five annual payments of ₹21,104.
Suppose your credit card states that interest on unpaid balances is 22 per cent APR, with interest compounded monthly. What is the effective annual rate of interest on unpaid balances?
If a mortgage requiring monthly payments is advertised of having a 6 per cent APR, what is the effective annual rate on this mortgage?
Which of the following represents the lowest cost of credit on an effective annual rate of interest rate basis?A: 10 per cent APR, interest compounded semi-annually B: 9.5 per cent APR, interest compounded quarterly C: 9.25 per cent APR, interest compounded monthly
Two years ago, Ram purchased the mobile at ₹10,000, he paid ₹2000 down and borrowed the rest. He took a fixed rate 60-month instalment at a rate of 8 per cent per year.The interest rate has fallen during the last two years. He has the option of refinancing the balance amount at a new fixed rate
You have been living in the house you bought ten years ago for ₹300,000. At that time, you took out a loan for 80 per cent of the house at a fixed rate of a 15-year loan at an annual stated rate of 9 per cent. You have just paid off the 120th monthly payment.The interest rate has meanwhile
Ramesh is purchasing his first car. The car costs ₹10,00,000. They need to pay 20 per cent down payment and refinance the rest of the amount. He is considering a fixed rate 30-year mortgage at a 5.25 per cent APR with monthly payments. How much will his first monthly payment be?
Ten years from now, Mr A will start receiving a pension of ₹3000 a year. The payment will continue for 16 years. How much is the pension worth now, if the interest rate is 10 per cent?
Mr X borrows ₹50,000 at 8 per cent compound interest. How much must he pay equally at the end of each year to settle his loan in five years? (round off decimals)
Ram borrows ₹3,000 to be paid back at the compound rate of 5 per cent per annum by the end of three years in three equal yearly instalments. How much will each instalment be? (rounded to the nearest whole rupee)
Sunshine technology is considering the following three projects, and it has to choose only one. Project A has an expense of ₹10,0000 today, and the cash flows over the next three years are ₹20,000, ₹40,000 and ₹70,000. Project B has an outflow of ₹1,10,000 and cash flows of ₹40,000,
Varun owned a factory that got burned down in an accident. The worth of vacant land is ₹70,000. He also received ₹2,00,000 from his insurance company. Varun plans to build another factory on the same land which will cost ₹2,75,000. He expects that the value of the finished factory in the
Which investment would you choose if you were offered the following two investments?Cash Flows YEAR A ( ₹) B ( ₹)TODAY ₹ − 1,000 ₹ − 1,000 1 ₹700 ₹0 2 ₹1,200 ₹2,100 The cost of capital for both investments is 10 per cent.+
Consider two investments, A and B Cash Flows YEAR A ( ₹) B ( ₹)TODAY −5,000 −5,000 1 1,000 0 2 2,000 0 3 2,000 4,000 4 1,500 1,000 5 1,000 2,500 Which investment is more profitable if the cost of capital of both investments is 7 per cent?
Dolly runs a boutique. She decides to expand her business. The additional rental space will cost her ₹7,200 per year at the end of each year and an immediate one-time investment of₹10,000 for other machines. The boutique will generate an extra income of ₹10,000 per year at the end of each
Hariti needs ₹12,000 to purchase the mobile she wants to purchase. Her father offers to loan her the money but wants to teach her the time value of money. He offers to have her repay the loan in the future using pocket money. They agree that she will repay₹4,500 in 3, 6, and 15 months from now.
Vanya’s parents have been putting money in an account for her since she was 5 years old.She has now turned 21 and has access to this money. Her mother asks her to guess what her account is worth today after she gives her a hint that they have invested ₹1,000 every year since her 5th birthday
She can make 7 per cent of returns on her account. How much money will she have at age 65 for her retirement?
Rama is 35 years old and wants to plan for her retirement. She decides to save ₹4,800 starting at the end of this year until she is
Daksh has ₹1,00,000 to decide on two investment options. Option 1 returns 60 per cent annually for four years, but he can invest ₹10,000 at the most. The return on Option 2 is 12 per cent annually for four years, but it would require the entire investment of₹1,00,000. Which option should
Rohan has ₹1,000 that he will invest in a safe financial instrument expected to return 3 per cent annually. Ananya has ₹500 which she invests in a stock market that is expected to return 7 per cent annually. Who will have more money after 20 years? And how much do they have in FV terms?
Ria decided to invest ₹15,000 in her savings account that pays 3 per cent interest, compounded quarterly. How much will she have in her account at the end of five years if she does not make any withdrawals?
Rajesh has deposited ₹100 in an account that pays 3 per cent compounded yearly. What would be the balance amount in his account at the end of three years if he withdrew only the interest on the interest each year?
Mr X has ₹1,00,000 today. He wants to invest this amount in his child’s education. Calculate the rate (compound annual growth rate) at which he should invest this amount to create a corpus of ₹45,00,000 after 20 years.
An investor invested ₹10,00,00 in a debt fund for the next ten years. Calculate the compound annual growth rate of the investment if he will receive ₹25,00,000 at maturity.
The country’s GDP (in crores) for ten years is given in the following table. Calculate the average annual growth rate over ten years.
The population of India according to census 2001 and 2011 are 1,028,737,436 and 1,210,193,422 respectively. Calculate the population growth rate.
During their first year of business, their profit was ₹3,00,000. After the sixth year, their yearly profit is ₹15,75,000. Calculate the growth rate.
The rainfall (in inches) and production of rice (in thousand million tonnes) is given next.Interpret the regression output as provided by Excel to test the significance of the regression coefficients. The agriculture officer claims that when rainfall increases by 1 inch the rice production
The literacy level (in percentage) and the number of people below the poverty line (as per cent of the total population) for 20 states are given next. Develop the regression model and test the significance of the regression model developed using a 95 per cent confidence interval approach.
Abhinav uploads videos on YouTube on Statistics and Economics concepts. The views and likes on 20 of his videos are given next. Abhinav believes that the number of views has a significant impact on the number of likes on the videos. Conduct the significance test to determine if the views (The X
The average annual income of 25 people and the taxes paid by them in ₹ are given in the following table. Develop the regression model and test the significance of the regression model developed using the p-values approach. (Significance level = 5 per cent).Individual Annual Income(X)Taxes
The area of the house (in sq. ft.) and the electricity bill (₹) is given next. Test the significance of the regression coefficients estimated using the t-statistics approach. (Significance level = 5 per cent).Area of the House (in sq. ft.)(X)Electricity Bill (in ₹)(Y)1,716 10,800 1,886 18,000
The price of artificial jewellery (₹) and the orders placed (units) for the last 15 months are given next. You are required to interpret the regression output and the residual output obtained using Excel data analysis option.
The annual profits (in crores) for a company and its average annual share prices (₹) for the last 15 years are given next. Calculate the residuals and interpret the results.
The rent (in ₹) and the area of the flats (in sq. ft.) for 20 houses in Delhi are given in the following table. Estimate the regression coefficients and find the rent value when the flat’s area is 7500 sq. ft.
The interest rate on loan charged by a bank and the demand for the loan (₹lacs) is given next. Estimate the values of the coefficients, and comment on the goodness of the fit of the model using the OLS method.
The working hours and the electricity consumption (in megawatts) in a factory are recorded for 20 days. Using an OLS method, estimate the values of the coefficients, and interpret the results.

Showing 200 - 300 of 1340

Basic Computational Techniques For Data Analysis An Exploration In MS Excel 2nd Edition D Narayana, Sharad Ranjan, Nupur Tyagi - Solutions

Step by Step Answers