# Excel_Mini_tab

A pharmaceutical manufacturer wants to investigate the bioactivity of a new drug. A completely randomized single-factor experiment was conducted with three dosage levels, and the following results were obtained.

a) Is there evidence to support a claim that the dosage level affects bioactivity? Use  = 0.05. If so which dosage levels are responsible for the difference? Support your conclusion with the appropriate test statistics and graphs.

b) Analyze the residuals from this experiment and comment on model adequacy.

An experiment was performed to study the effects of three different types of 32-ounces bottles and three different shelf types (B) – smooth permanent shelves, end-aisle display with grilled shelves, and beverage coolers- on the time it takes to stock 12-bottle cases on the shelves. Three workers (factor C) were employed in the experiment, and two replicates of a 33 factorial design were run. The observed time data are shown in the following table. Analyze the data and draw conclusions.

Harry and Judy Peterson-Nedry own a vineyard and winery in Newberg, Oregon. They grow several varieties of grapes and manufacture wine. Harry and Judy have used factorial designs for process and product development in the winemaking segment of their business. This problem describes the experiment conducted for their 1985 Pinot Noir. Eight variables shown below, were originally studied in the experiment:

Variable Low Level (-) High level (+)

A = Pinot Noir Pommard Wadenswill

B = Oak type Allier Troncais

C = Age of barrel Old New

D = Yeast/skin contact Champagne Montrachet

E = Stems None All

F = Barrel toast Light Medium

G = Whole cluster None 10%

H = Fermentation temperature Low (75oF max) High (92oF max)

Harry and Judy decide to use a design with 16 runs. The wine was tasted by a panel of experts on March 8, 1986. Each expert ranked all 16 samples of wine tasted, with rank 1 being the best. The design and the taste-test panel results are shown below.

(a) What are the alias relationships in the design selected by Harry and Judy?

(b) Use the average ranks ( ) as a response variable. Analyze the data and draw conclusions.

(c) Use the standard deviations of the ranks (or some appropriate transformations such as log standard deviation s) as a response variable. What conclusions can you draw about the effects of the eight variables on variability in wine quality?

(d) After looking at the results Harry decide that one of the panel members (DCM) knows more about beer than he does about wine, so they decide to delete his ranking. What effect would have this have on the results and conclusions from parts (b) and (c)?

Consider the three variable central composite design shown below. Analyze the data and draw conclusions, assuming that we wish to maximize conversion (y1) with activity (y2) between 55 and 60. Perform a thorough analysis, including the response surface model for each variable. (Note need to do one variable at a time).

Квалификация: Excel, Minitab, Excel Macros

О работодателе:
( 610 отзыв(-а, -ов) ) Bangalore, India

ID проекта: #24729394

## 10 фрилансеров(-а) в среднем готовы выполнить эту работу за ₹1825

Mendeznatera

You can see my Google Academics profile at [login to view URL] and ResearchGate profile at [login to view URL] I will do all the tasks that you assign. I Больше

₹2000 INR за 7 дней(-я)
(4 отзывов(-а))
3.0
clearatul0

1st one can be done using t test and 2nd one is general statistics. Do you want to automate this or just prepare a one time templatized sheet. I have 6 years of experience in Excel Macros. I can help to separate/combi Больше

₹1500 INR за 7 дней(-я)
(3 отзывов(-а))
2.8
Dhanushvik

Hello sir/mam : I'm here to work for a data entry . I was experience in data entry offer me job , I'll complete with a perfection Relevant Skills and Experience I have worked in many data entry job offer me a work .

₹2000 INR за 10 дней(-я)
(0 отзывов(-а))
0.0
rohitsingh251200

Hello, I am native english speaker, reader and writer. I am very interested to work on your project and very eager to know the topic to write about . I offer wide range of time and the time stated is for the fact tha Больше

₹1750 INR за 1 день
(0 отзывов(-а))
0.0
Maniss28

Fast service at low price

₹2000 INR за 10 дней(-я)
(0 отзывов(-а))
0.0
Shanawas11

I am an engineer, I worked as General Manager in Private company. I have lot of knowledge in Excel..

₹1501 INR за 2 дней(-я)
(0 отзывов(-а))
0.0
premshri4

₹kdkdkdkckckckclkkccmcmckclclclclccmcnakksmcndkkflclcmxkckxieospdpkxkcncmvlclcclclvvmmvkkvkclcpclflfvckcklpdpkfkckcncmmcmcmcmkfkldl

₹2000 INR за 3 дней(-я)
(0 отзывов(-а))
0.0

Hiii there, I am Pradeep gour, i am a full time freelancer, i have an 5 years experience as a data entry expert. I hope you are doing well! I am very much interested in your project. It will be my great pleasure to wor Больше

₹1500 INR за 2 дней(-я)
(0 отзывов(-а))
0.0
aqeelalyani5

Minitab expert Relevant Skills and Experience Statistical software

₹2000 INR за 10 дней(-я)
(0 отзывов(-а))
0.0
₹2000 INR за 10 дней(-я)
(0 отзывов(-а))
0.0