Document (21)

Person (SSN, Name, Surname, DateOfBirth, Gender) SerologicalTest (CodT, CommercialName, Brand, Reliability) Building(CodB, City, Province Region, MaxCapacity) UndergoTest (SSN, CodT, Date, CodB, Outcome)    For each serological test brand, find the brand and the overall number of tests undergone from May 1st, 2020 to June 30th, 2020 to persons who have undergone at least two tests with the outcome “Positive” of that brand.   this is the solution.  SELECT Brand, COUNT(*) FROM SerologicalTest ST, UndergoTest UT WHERE ST.CodT = UT.CodT AND Date >= 01/05/2020 AND Date <= 30/06/2020 AND SSN IN (      Select SSN      From UndergoTest UT2, SerologicalTest ST2      where ST2.CodT = UT2.CodT and outcome='positive'             and ST2.Brand = ST.Brand      group by SSN      having COUNT(*) > 1) GROUP BY Brand     but im struggling a lot to be able to solve these type of questions im not understanding how to think about it and if i can somehow do something on a paper before starting to…

plz answer all questions C.The data below shows results for three treatments and weight results obtained from anexperiment on beetles. WeightsTreatment 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 above2. Is there any significant difference between the average weights of beetles in the 3experimental conditions?D.The studies below shows results for three plant extract treatment (extracts 1-3) andbiomass results obtained from an experiment on bacteria.               BiomassExtract1 (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 above2. Is there any significant difference between the average biomass of bacteria treatedwith the three extracts?

Major Vegetables and Root Crops Quarterly Bulletin, April-June 2023 September 2023 Production of cabbage during the second quarter of 2023 was registered at 23.33 thousand metric tons. This represents a decrease of -4.5 percent from the 24.44 thousand metric tons recorded output in the same quarter of 2022. CAR was the leading producer of cabbage with 18.50 thousand metric tons or 79.3 percent share to the total production during the quarter. This was followed by Central Visayas with 1.38 thousand metric tons or 5.9 percent share. The January to June 2023 area harvested for cabbage was estimated at 2.94 thousand hectares. This was 0.6 percent higher than the same period of previous year’s level of 2.92 thousand hectares. what is the cause of the decrease in production? what is the critical baguio vegetable production has decreased these past few years?

Computer Science Analyze the titanic dataset by applying the various relevant techniques taught in class starting from cleaning the data, imputing data, and finally visualizing the data. Provide justification as to why you are using a technique. To receive full points, you should have appropriate cleaning and/or data transformation steps, charts/plots should be meaningful with no overlapping labels. I should see at least 5 different types (bar, line, pie, etc) of charts. You should have a conclusion by highlighting the most important insight you derived from the dataset

Which of the following statements are true for bias and variance O Classifiers with low bias typically have low variance Classifiers with low bias typically have high variance Bias and variance typically do not have any dependency on each other

Using box and whisker plot, what do we get? * a) Interquartile Range (IQR) and the outliers   b) Mean, median, and mode   c) Variance   d) The range of the data

One hundred students were asked whether they had taken courses in any of the three subjects, Mathematics, Computer Science and Information Technology. The results were given below. 45 had taken Mathematics; 18 had taken Mathematics and Computer Science; 38 had taken Computer Science; 21 had taken Information Technology; 9 had taken Mathematics and Information Technology.; 4 had taken Computer Science and Information Technology and 23 had taken no courses in any of the subjects. Draw a Venn diagram that will show the results of the survey.

Software randomization: how? How should rand function values be resized or shifted?

Use the following diagram relation to perform the normalization. You need to provide the 2NF and 3NF.

create flowhart diagram RAW DATA PRE SAMPLES PRE SAMPLE TASK 1 PRE SAMPLE TASK 2 PRE SAMPLE TASK 3  PRE SAMPLE TASK 4 PRE SAMPLE TASK 4 LEVEL 1 PRE SAMPLE TASK 4 LEVEL 2 PRE SAMPLE TASK 4 LEVEL 3 3. EVALUATION  4. ANALYSIS 5. COMPARISON 6. CONCLUSION    note: each step and sub levels should be don in order to proceed

The process of data before calculating correlations is a prudent way to get good correlations.

for a 1000x5 matrix where each column is a specific data for profit  r=randi(10,1000,5) write a matlab code that asks the user from which of 5 column to select and to display the count to the user the number of days each value in the selected column was higher than the overall mean of the matrix.please use matlab!

Explain the Clark-Wilson Model Edit View Insert Format Tools Table 12pt v Paragraph v BI U ...

Plot following curves in the SAME figure where x-axis is "Model Complexity" and y-axis is the value: (1) Bias; (2) Variance; (3) Training Accuracy; (4) Testing Accuracy; [Paste your plot here]

PLEASE ANSWER USING SAS.

Problem 6 Plotting variability and uncertainty   Plot error bars that visualize 95% confidence intervals of the estimates of the average bacteria populations at a sequence of time steps. More specifically, you need to implement the function   showErrorBars          according to the behavior described in the docstring specifications in the below code cell.   Note that the data used to produce the error bars are based on the populations collected in problem 4. The calc_95_ci defined in problem 5 should be used to provide the standard error data to produce the plot.   ########################## # PROBLEM 6 ##########################   def showErrorBars(populations, steps, num_steps, num_trials):     """     Plot error bars to represent confidence intervals of the estimates     of the average bacteria populations at a sequence of time steps.     Args:         populations (list of lists or 2D array): populations[i][j] is the             number of bacteria present in trial i at time step j…

Please do these 2

The proportion of variance explained by a principal component (PVE) is the variance of this principal component over the total variance of the dataTrueFalse

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.

How is discrepancy computed?

For interval data, what correlation coefficient would you use?

QUESTION 1 An admission charge for Bandar Orchid Wetlands varies according to the age of the customer as in Figure 1. The system will receive the input for the number of persons for each category as in Figure 2. Then, it will calculate and display the total charge (include SST 8%) and the category Figure 3. [Assume all items are required. The process is not involving any decision]. Category (Age) 50 and above 13- 49 7-12 4-0 Charge (RM) 30.00 35.00 25.00 15.00 Below 4 Figure 1: Charges for Visitors Free The Bold items are the input from the user. WELCOME TO BANDAR ORCHID WETLANDS Enter the number of persons for each category Age Over 50 Age 13 - 50 Age 7 - 12 Age 4 - 6 Age Below 4 1 2 Figure 2: The Input Total for Over 50 (1 Fersons): BM 30.00 Total for 13 - 50 (2 Persons): RM 70.00 Total for 7 - 12 (4 Persons): RM 100.00 Total for 4 - 6_(O Persons): RM 0.00 Total for Below 4 (FREE) : RM 0.00 ITEMS RM 200.00 12.00 TOTAL 3ST (6R) SUB-TOTAL = 212.00 THANK YOU.ENJOY YOUR HOLIDAY!! Figure…

Explain how Logistic Regression works. Note: Please do it with your own words. Thankyou

Analytical data is the fundamental distinction between BI and adalytic data.

am attempting to create 3 individual plots A plot of HARPS-N CCF data. This data is freely available on the DACE website. I have been able to create this plot and it produces a signature "V" shape. A plot of the Mean of the CCF data, same shape. A residuals plot. This is where I am having the difficulty, I have coded as much can. The shape of the plot should be "dumbbell" in shape. At the moment I am getting an empty plot. This is the code that I have so far.. #import libsimport matplotlib.pyplot as pltimport globfrom astropy.io import fitsfrom astropy.wcs import WCSimport numpy as np # Initial plotfig, ax = plt.subplots(figsize=(10, 10)) # data from the FITSdata_dir = glob.glob('/Users/xxxxx/Desktop/harpn_sun_release_package_ccf_2018/2018-01-18/*.fits') # empty lists for storagelams = []fluxs = [] # read the the FITSfor file_path in data_dir:    hdul = fits.open(file_path)    data = hdul[1].data    h1 = hdul[1].header    flux = data[1]    w = WCS(h1, naxis=1, relax=False,…

Explain analytical and olaP Functions?