Use the appropriate excel data analysis tool from the tool pack as the basis to determine...
Use the appropriate excel data analysis tool from the tool pack as the basis to determine the standard error of the mean differences for the following before and after data. Input your answer to three decimal places
Data set 1: 34, 26, 54, 12, 43,67, & 9
Data set 2: 32, 18, 60, 18, 35, 70, & 15
Homework Answers
Add Answer to:
Use the appropriate excel data analysis tool from the tool pack
as the basis to determine...
Using the data in the file named “Dataset 1,” to determine is there was a change...
Using the data in the file named “Dataset 1,” to determine is there was a change in the number of tons of paper used after the implementation of a recycling program in 25 different districts. a. Is this study using dependent or independent samples? b. What is your research hypothesis? c. Using Excel, calculate your test statistic and p-value. Paste the output here. d. What do you conclude? Below is the data set that is mentioned above Before Recycling 20...
use the appropriate numerical measure to determine which of the following data sets has larger variation....
use the appropriate numerical measure to determine which of the following data sets has larger variation. set 1. 22, 28, 32, 23, 26, 38, 40, 18 set 2. 70, 72, 64, 60, 62
Instructions for Excel Assignment a) Using the data in the file (i.e., the values of Y...
Instructions for Excel Assignment
a) Using the data in the file (i.e., the values of Y and values
of X), create a scatter plot with the variable Y plotted vertically
and the variable X plotted horizontally. You are to add a
trendline, the equation of the line and R2 to this scatter plot.
You do not need to add a title to this plot.
b) Run the ‘Regression’ analysis tool (found under DATA/Data
Analysis). The output using this tool should...
6.5 An engineer is interested in the effects of cutting speed (A), tool geometry (B), and cutting...
Solve parts b and d by using SPSS
6.5 An engineer is interested in the effects of cutting speed (A), tool geometry (B), and cutting angle (C) on the life (in hours) of a machine tool. Two levels of each factor are chosen, and three replicates of a 2 factorial design are run. The results are as follows: Replicate Treatment B C Combination 22 31 32 43 35 34 50 55 47 46 44 40 37 36 60 50 54...
Please use the accompanying Excel data set or accompanying Text file data set when completing the...
Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise. The following data are the joint temperatures of the O-rings (°F) for each test firing or actual launch of the space shuttle rocket motor (from Presidential Commission on the Space Shuttle Challenger Accident, Vol. 1, pp. 129-131): 83 46 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53...
Student Name Student Number 18. Describe the center and spread of the data using either the...
Student Name Student Number 18. Describe the center and spread of the data using either the mean and standard deviation or the five-number summary. Justify your choice by constructing a box-and-whisker plot for the data. Be sure to include the scale. A. 47, 16, 70, 80, 28, 33, 91, 55, 60, 45, 86, 54, 30, 98, 34, 87, 44, 35,64,58, 27,67, 72,68, 31, 95, 37, 41, 97,56, 49, 71, 84, 66, 45, 93 B. 40, 39, 37, 26, 25, 40,...
Ent //n Data and Calculations: Enter your experimental data and calculations in the data sheet below....
Ent //n Data and Calculations: Enter your experimental data and calculations in the data sheet below. g/mol Qmmonium g/mol B6.043 LLo. 95 Determination of the Heat of Solution Molecular weight of: NH.NO, (Salt A) CaCl (Salt B) 27 0 s): With NH4NO, With CaCl C Temperature of water before mixing (t (a) Temperature of solution after mixing: 10 100 110 90 120 80 70 60 5C 3C 40 20 Time (s) Salt A 841 35 8s 35 33 32 32...
Hi, See the data set below. Based on this, Excel comes with the following analysis (paired diffe...
Hi,
See the data set below.
Based on this, Excel comes with the following analysis (paired
difference).
I need to calculate a 95% confidence interval. Based on this, I
came to the following formula: [Mean of the difference (D-mean) +/
t(alpha/2) * Sd / sqrt(n)]. I can fill in the following
information:
D-mean = 27-34 = -7.
t(alpha/2) = 2,262
sqrt(n) = sqrt(10)
Do you now how I can find the standard deviation of the sample?
(Sd) I think it...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for central tendency and using the Data Analysis Pack. Click Data Click Data Analysis .In the pop-up list click on Descriptive Statistics and hit OK . In the pop-up box in the input range type A2:A75 or highlight this region . Click the box next to summary statistics Click OK A box of summary statistics will appear like the one below Mean Standard Error Median Mode Standard...
The accompanying computer excel output (please see attachment on Blackboard) provides details of data and analysis...
The accompanying computer excel output
(please see attachment on Blackboard) provides details of data and
analysis on the topic of “patient satisfaction”. A hospital
administrator wished to study the relation between patient
satisfaction (Y) and patients’ age (X1, in years) , severity of
illness (X2), and anxiety level (X3).
The output includes a listing of all
46 observations; descriptive statistics for each variable; and, the
results of a regression analysis that uses patient satisfaction as
the dependent variable, and patient’s...
Instructions for Excel Assignment
a) Using the data in the file (i.e., the values of Y and values
of X), create a scatter plot with the variable Y plotted vertically
and the variable X plotted horizontally. You are to add a
trendline, the equation of the line and R2 to this scatter plot.
You do not need to add a title to this plot.
b) Run the ‘Regression’ analysis tool (found under DATA/Data
Analysis). The output using this tool should...
Solve parts b and d by using SPSS
6.5 An engineer is interested in the effects of cutting speed (A), tool geometry (B), and cutting angle (C) on the life (in hours) of a machine tool. Two levels of each factor are chosen, and three replicates of a 2 factorial design are run. The results are as follows: Replicate Treatment B C Combination 22 31 32 43 35 34 50 55 47 46 44 40 37 36 60 50 54...
Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise. The following data are the joint temperatures of the O-rings (°F) for each test firing or actual launch of the space shuttle rocket motor (from Presidential Commission on the Space Shuttle Challenger Accident, Vol. 1, pp. 129-131): 83 46 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53...
Student Name Student Number 18. Describe the center and spread of the data using either the mean and standard deviation or the five-number summary. Justify your choice by constructing a box-and-whisker plot for the data. Be sure to include the scale. A. 47, 16, 70, 80, 28, 33, 91, 55, 60, 45, 86, 54, 30, 98, 34, 87, 44, 35,64,58, 27,67, 72,68, 31, 95, 37, 41, 97,56, 49, 71, 84, 66, 45, 93 B. 40, 39, 37, 26, 25, 40,...
Ent //n Data and Calculations: Enter your experimental data and calculations in the data sheet below. g/mol Qmmonium g/mol B6.043 LLo. 95 Determination of the Heat of Solution Molecular weight of: NH.NO, (Salt A) CaCl (Salt B) 27 0 s): With NH4NO, With CaCl C Temperature of water before mixing (t (a) Temperature of solution after mixing: 10 100 110 90 120 80 70 60 5C 3C 40 20 Time (s) Salt A 841 35 8s 35 33 32 32...
Hi,
See the data set below.
Based on this, Excel comes with the following analysis (paired
difference).
I need to calculate a 95% confidence interval. Based on this, I
came to the following formula: [Mean of the difference (D-mean) +/
t(alpha/2) * Sd / sqrt(n)]. I can fill in the following
information:
D-mean = 27-34 = -7.
t(alpha/2) = 2,262
sqrt(n) = sqrt(10)
Do you now how I can find the standard deviation of the sample?
(Sd) I think it...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for central tendency and using the Data Analysis Pack. Click Data Click Data Analysis .In the pop-up list click on Descriptive Statistics and hit OK . In the pop-up box in the input range type A2:A75 or highlight this region . Click the box next to summary statistics Click OK A box of summary statistics will appear like the one below Mean Standard Error Median Mode Standard...
The accompanying computer excel output
(please see attachment on Blackboard) provides details of data and
analysis on the topic of “patient satisfaction”. A hospital
administrator wished to study the relation between patient
satisfaction (Y) and patients’ age (X1, in years) , severity of
illness (X2), and anxiety level (X3).
The output includes a listing of all
46 observations; descriptive statistics for each variable; and, the
results of a regression analysis that uses patient satisfaction as
the dependent variable, and patient’s...
Most questions answered within 3 hours.
-
An aqueous solution of barium hydroxide is
standardized by titration with a 0.196 M solution
of...
asked 5 minutes ago -
accorsing to the data from thw college board, the mean wuantitive
Sat score for s demale...
asked 1 hour ago -
1- What are 5 general characteristics of Botticelli’s
paintings?
2- Describe 5 important traits of Flemish...
asked 2 hours ago -
A golfer claims that his average golf score at the course he
plays regularly is less...
asked 3 hours ago -
On May 1, First Bank perfected a security interest in Debtor’s
inventory. On June 1, Bob...
asked 3 hours ago -
A new kind of typhoid shot is being developed by a medical
research team. The old...
asked 5 hours ago -
Write a chemical equation for these reactions. (Use
the lowest possible whole number coefficients.) Include
states-of-matter...
asked 7 hours ago -
For each of the Z-scores below, determine two probabilities
(show four three decimal places): (1) the...
asked 7 hours ago -
Oxidative phosphorylation is achieved through chemiosmotic
coupling, which turns chemical energy into osmotic potential energy
that...
asked 10 hours ago -
Hollywood Shoes would like to maintain their cash account at a
minimum level of $64,000, but...
asked 10 hours ago -
Proteins CtrA-P, DnaA, and GcrA behave similarly to what
molecule in the Eukaryotic Cell Cycle?
asked 10 hours ago -
TRUE OR FALSE
In case of a competitive tender procedure, in the request for
quotation, the...
asked 10 hours ago