Question

In: Math

Define the data you ( Any Date set could be used ) want to study in...

Define the data you ( Any Date set could be used ) want to study in order to solve a problem or meet an objective:

Find a data-set and analyse it for a project. to answer following questions:

What are the observations (Cases)?

What are the variables?

Variables are qualitative or quantitative define?

What interesting questions could it help you answer?

Please share the screen shot of the data.

Solutions

Expert Solution

Sol:

Find a data-set and analyse it for a project. to answer following questions:

mtcars dataset in R studio

variables are:

"mpg" "cyl" "disp" "hp" "drat" "wt" "qsec" "vs" "am" "gear" "carb"

there were 11 varaibles

and 32 observations

Type mpg cyl disp hp drat wt qsec vs am gear carb
Mazda RX4 21 6 160 110 3.9 2.62 16.46 0 1 4 4
Mazda RX4 Wag 21 6 160 110 3.9 2.875 17.02 0 1 4 4
Datsun 710 22.8 4 108 93 3.85 2.32 18.61 1 1 4 1
Hornet 4 Drive 21.4 6 258 110 3.08 3.215 19.44 1 0 3 1
Hornet Sportabout 18.7 8 360 175 3.15 3.44 17.02 0 0 3 2
Valiant 18.1 6 225 105 2.76 3.46 20.22 1 0 3 1
Duster 360 14.3 8 360 245 3.21 3.57 15.84 0 0 3 4
Merc 240D 24.4 4 146.7 62 3.69 3.19 20 1 0 4 2
Merc 230 22.8 4 140.8 95 3.92 3.15 22.9 1 0 4 2
Merc 280 19.2 6 167.6 123 3.92 3.44 18.3 1 0 4 4
Merc 280C 17.8 6 167.6 123 3.92 3.44 18.9 1 0 4 4
Merc 450SE 16.4 8 275.8 180 3.07 4.07 17.4 0 0 3 3
Merc 450SL 17.3 8 275.8 180 3.07 3.73 17.6 0 0 3 3
Merc 450SLC 15.2 8 275.8 180 3.07 3.78 18 0 0 3 3
Cadillac Fleetwood 10.4 8 472 205 2.93 5.25 17.98 0 0 3 4
Lincoln Continental 10.4 8 460 215 3 5.424 17.82 0 0 3 4
Chrysler Imperial 14.7 8 440 230 3.23 5.345 17.42 0 0 3 4
Fiat 128 32.4 4 78.7 66 4.08 2.2 19.47 1 1 4 1
Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.9 1 1 4 1
Toyota Corona 21.5 4 120.1 97 3.7 2.465 20.01 1 0 3 1
Dodge Challenger 15.5 8 318 150 2.76 3.52 16.87 0 0 3 2
AMC Javelin 15.2 8 304 150 3.15 3.435 17.3 0 0 3 2
Camaro Z28 13.3 8 350 245 3.73 3.84 15.41 0 0 3 4
Pontiac Firebird 19.2 8 400 175 3.08 3.845 17.05 0 0 3 2
Fiat X1-9 27.3 4 79 66 4.08 1.935 18.9 1 1 4 1
Porsche 914-2 26 4 120.3 91 4.43 2.14 16.7 0 1 5 2
Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.9 1 1 5 2
Ford Pantera L 15.8 8 351 264 4.22 3.17 14.5 0 1 5 4
Ferrari Dino 19.7 6 145 175 3.62 2.77 15.5 0 1 5 6
Maserati Bora 15 8 301 335 3.54 3.57 14.6 0 1 5 8
Volvo 142E 21.4 4 121 109 4.11 2.78 18.6 1 1 4 2

variables are quantitative

mpg cyl disp hp drat wt qsec vs am gear carb

Type is qualitative

What interesting questions could it help you answer?

to predict mpg from other variables

Regression output is


Call:
lm(formula = mpg ~ ., data = mtcars)

Residuals:
Min 1Q Median 3Q Max
-3.4506 -1.6044 -0.1196 1.2193 4.6271

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 12.30337 18.71788 0.657 0.5181
cyl -0.11144 1.04502 -0.107 0.9161
disp 0.01334 0.01786 0.747 0.4635
hp -0.02148 0.02177 -0.987 0.3350
drat 0.78711 1.63537 0.481 0.6353
wt -3.71530 1.89441 -1.961 0.0633 .
qsec 0.82104 0.73084 1.123 0.2739
vs 0.31776 2.10451 0.151 0.8814
am 2.52023 2.05665 1.225 0.2340
gear 0.65541 1.49326 0.439 0.6652
carb -0.19942 0.82875 -0.241 0.8122
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 2.65 on 21 degrees of freedom
Multiple R-squared: 0.869,   Adjusted R-squared: 0.8066
F-statistic: 13.93 on 10 and 21 DF, p-value: 3.793e-07

Regression eq to predict mpg from other variables is

mpg=12.30337416 -0.11144048*cyl+ 0.01333524*disp -0.02148212*hp + 0.78711097*drat -3.71530393*wt+ 0.82104075*qsec


Related Solutions

What would you want to study? If you could create a poll or survey, what would...
What would you want to study? If you could create a poll or survey, what would your topic be? Describe your population (the type of person you want), sample (n = ?), one to three questions you would ask, and how you would graph the results......In about 200 words.
Orginial Discussion Question: What would you want to study? If you could create a poll or...
Orginial Discussion Question: What would you want to study? If you could create a poll or survey, what would your topic be? Describe your population (the type of person you want), sample (n = ?), one to three questions you would ask, and how you would graph the results. Example: What would you desire to study? Many of my peers are present men and women online. he description of my sample would be a random sample that includes 30 prospective...
What would you want to study? If you could create a poll or survey, what would...
What would you want to study? If you could create a poll or survey, what would your topic be? Describe your population (the type of person you want), sample (n = ?), one to three questions you would ask, and how you would graph the results.
In this question you are going to calculate the data that could be used to construct...
In this question you are going to calculate the data that could be used to construct a titration curve (pH versus volume of titrant added) for the titration of an aqueous ammonia (NH3; weak base, pKB = 4.7) cleaning solution with a strong acid (HCl). When strong acid is added to an aqueous solution, it immediately reacts and yields H3O + ions; thus the titration is described by the reaction: NH3(aq) + H3O + (aq)  NH4 + + H2O(l)...
I want you to evaluate at least three categories of data that could be found in...
I want you to evaluate at least three categories of data that could be found in a healthcare organization and to determine the relative value of that data to an outside attacker. Categories of information could include health history, scheduled procedures, lab test results, medication record, payer information (e.g. Insurance, Medicaid, Medicare info), personal information (including birthdate, address, ssn), or others. Indicate the following for each of the three categories you choose: 1. Type(s) of harm that could occur from...
For this assignment, I want you to evaluate at least three categories of data that could...
For this assignment, I want you to evaluate at least three categories of data that could be found in a healthcare organization and to determine the relative value of that data to an outside attacker. Categories of information could include health history, scheduled procedures, lab test results, medication record, payer information (e.g. Insurance, Medicaid, Medicare info), personal information (including birthdate, address, ssn), or others. Indicate the following for each of the three categories you choose: 1. Type(s) of harm that...
Researchers want to study Drug-induced liver injury (DILI). DILIscore in the data set indicates how serious...
Researchers want to study Drug-induced liver injury (DILI). DILIscore in the data set indicates how serious the injury is. From the data, please answer the following questions(you can use R): 1. Report descriptive statistics (Summary statistics, histogram and boxplots for numerical variables and frequency table for categorical variables) and outliers (if there is any). 2. Use correlation analysis to find if DILIscore is significantly correlated with patient age? Is DILIscore significantly correlated with drug dose? 3. Use T test to...
In this discussion, you will pick any set of data from the textbook or your own...
In this discussion, you will pick any set of data from the textbook or your own data. Conduct a confidence interval analysis. Explain in the discussion question: Your source of data The lower limit and upper limit How this information might be relevant to a decision maker. Attach the Excel file containing the data source (but be sure everything we need to know about your executive summary is in the body of the discussion forum, not the attachment).
An important practice is to check the validity of any data set that you analyze. One...
An important practice is to check the validity of any data set that you analyze. One goal is to detect typos in the data, and another would be to detect faulty measurements. Recall that outliers are observations with values outside the “normal” range of values of the rest of the observations. Specify a large population that you might want to study and describe the type numeric measurement that you will collect (examples: a count of things, the height of people,...
The following is a small data set of 25 observations. I want you to calculate some...
The following is a small data set of 25 observations. I want you to calculate some statistics by hand to cement the class material. You can use the regular formula for the variance or the computational formula - I’m just interested in the correct result. If you use the computational formula, you will want to calculate a separate row of each value squared in order to calculate the Sum(x^2). Excel can be used to solve this problem. VarX 44 34...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT