plz answer all questions C. The data below shows results for three treatments and weight results obtained from an experiment on beetles. Weights Treatment 1 (52,46,62,48,57,54) Treatment 2 (66,49,64,53,68) Treatment 3 (63,65,58,70,71,73) 1. Create a data-frame for the results above 2. Is there any significant difference between the average weights of beetles in the 3 experimental conditions? D. The studies below shows results for three plant extract treatment (extracts 1-3) and biomass results obtained from an experiment on bacteria. Biomass Extract1 (64, 66, 68, 75, 78, 94, 98, 79, 71, 80) Extract2 (91, 92, 93, 85, 87, 84, 82, 88, 95, 96) Extract3 (79, 78, 88, 94, 92, 85, 83, 85, 82, 81) 1. Create a data-frame for the results above 2. Is there any significant difference between the average biomass of bacteria treated with the three extracts?

plz answer all questions C. The data below shows results for three treatments and weight results obtained from an experiment on beetles. Weights Treatment 1 (52,46,62,48,57,54) Treatment 2 (66,49,64,53,68) Treatment 3 (63,65,58,70,71,73) 1. Create a data-frame for the results above 2. Is there any significant difference between the average weights of beetles in the 3 experimental conditions? D. The studies below shows results for three plant extract treatment (extracts 1-3) and biomass results obtained from an experiment on bacteria. Biomass Extract1 (64, 66, 68, 75, 78, 94, 98, 79, 71, 80) Extract2 (91, 92, 93, 85, 87, 84, 82, 88, 95, 96) Extract3 (79, 78, 88, 94, 92, 85, 83, 85, 82, 81) 1. Create a data-frame for the results above 2. Is there any significant difference between the average biomass of bacteria treated with the three extracts?

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 1.6CP

See similar textbooks

Similar questions

in R please provide the code for the Test for Homogeneity using the Cars93 dataset:a. Load the Cars93 data setb. Create a new data frame that has the counts of the number of cars of each type with each drivetrain using the table function. View new tablec. Conduct a chi-squared test to see if the distribution of cars with each drivetrain is the same for each car type. Clearly state the hypothesis, test results, conclusion and justification
Using the images of the dataset below, please answer the following questions NOTE: All answers should be supported by coding and/or some written discussion. 1. Explain what this dataset about?Hint: You may need to look at columns, rows, and cells to understand the dataset. 2. Define the neighbor hood and the year where was the biggest square feetHint: You may use .max() method 3. Is there is any relation between the income and the square feet?Hint: You may need to draw (plot) your dataset. 4. For each minimum net income in the dataset, what was the years?Hint: You may use grouped and aggregated calculations 5. Reshape the dataset based on units and value.Hint: You may apply tidy data approaches
Step 1 Build a train/test split using Amazon data. Dataset name is amzn. Training Data starts in 2016. Testing Data is last 10 observations in dataset. Both should be pandas series type indexed by date. The last date in train should be '2017-12-14' Train = ?? Test = ?? Step 2 Adjust the ARIMA instance below to build an autoregression model using your training data from Step 1. This model should work on the first difference of the original closing price, and use one prior term or an order 1 AR model. from statsmodels.tsa.arima_model import ARIMA ar = ARIMA(train, order = (0, 0, 0)) model = ?? Python Programming
Question p .Suppose that the data for analysis includes the attribute age. The age values for the data tuples are (in increasing order) 13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25, 25, 25, 25, 30, 33, 33, 35, 35, 35, 35, 36, 40, 45,46, 52, 70. Show a boxplot of the data? Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Write a R-code to find mean, median and mode for your own raw data of 15 observations. Give the suitable labels to the findings.
when a data set is unimodal, and the IQR is equal to the median that both equal to 50. However, median is equal to 100. Please explain what is the distribution?
Retrieve the "UndergradSurvey.xls" file from the item posted in the Final Exam Week content folder (next to this Exam). Using Excel, create a multiple linear regression to predict the salary expectation (column I) of undergraduate students using their Age (column C), GPA (column G), and gender (column B) as the independent variables. Code the gender variable as 1 = female and 0 = male. What is the numeric value of the slope coefficient associated with Age in this model? (Round your answer to 3 decimals).
Load & check the data: breat_cancer dataset8. Split your data into train 80% train and 20% test, use the last two digits of your student numberfor the seed.Build Classification ModelsSupport vector machine classifier with linear kernel 9. Train an SVM classifier using the training data, set the kernel to linear and set the regularizationparameter to C= 0.1. Name the classifier clf_linear_firstname.10. Print out two accuracy score one for the model on the training set i.e. X_train, y_train and theother on the testing set i.e. X_test, y_test. Record both results in your written response.11. Generate the accuracy matrix. Record the results in your written response.Support vector machine classifier with “rbf” kernel12. Repeat steps 9 to 11, in step 9 change the kernel to “rbf” and do not set any value for C.Support vector machine classifier with “poly” kernel13. Repeat steps 9 to 11, in step 9 change the kernel to “poly” and do not set any value for C.Support vector machine…
The first step in finding an association between gender and handedness from among the students in the accompanying table is to create a two-way table with these two variables. Make a two-way table with the labels Male and Female across the top and the labels Right and Left on the side, and then answer questions (a) through (f) using it. LOADING... Click the icon to view the data table. a. Report how many students are in each of the four cells of the table by writing these values in your table. Refer to the spreadsheet given below to begin tallying. For each cell, make a tally mark using the capital letter I for each person who has both of the characteristics belonging to that cell. Type a 0 if there are no students with the given characteristics. The genders have been recorded without coding to make the tallying process a little easier. Put a check mark to the right of the table so you know how far you have gotten. The first four tally marks are given. Check to…
DATASCIENCE For the given labeled data set below,determine the minimum value of K so that query point ""?"" is classified as negative.
What are the anomalies present on the given data below? Provide basic steps in solving those anomalies.
Draw column graph, bar graph, and Pivot graph of the following dataset and attached the screenshots. Give proper chart title along with your name and id, as well as slicer where required.