Blog

Given the following Movies relation: Write the SQL queries to answer the following:  1) Find the Title and StudioName of movies released in the year 2010 and have the genre as ‘Sci-Fi’ 2) Find the StudioName of all studios located in Los Angeles. 3) Find the Title of movies that start with the word “Jurassic” and end with exactly five characters. Use pattern for this question. (Do not use % for this question)  4) Find the Title, Year, and Genre of all movies that are not of genre Romance. Use a pattern to exclude the Romance genre.

Essay Question Instructions: Make sure you show all work on the five essay questions on scratch paper. Upload a PDF of your written work to the Canvas Upload module immediately after you finish the test. Most of the points are awarded based on your written work, not the final answer that you submit to each question. Essay Question 2: The PLNU is trying to determine if basketball players weigh more that baseball players.  A random sample was taken of  43 basketball players and their mean weight was 196 lbs with a standard deviation of 21.4 lbs.  A random sample of  59 baseball players was taken and their mean weight was 187 lbs with a standard deviation of 16.8 lbs.  Give a 95% confidence interval for the mean difference in the average weights of PLNU basketball and baseball players. Be sure to show all formulas, work and numbers used ( e.g. df & critical value) .  At the end of your work, write a one or two sentence summary in non-statistical language to describe what you have found, not how you found it. Your audience is people who have never had a statistics class. The PLNU is trying to determine if basketball players weigh more than baseball players.  A random sample was taken of  53 basketball players and their mean weight was 192 lbs with a standard deviation of 23.4 lbs.  A random sample of  62 baseball players was taken and their mean weight was 187 lbs with a standard deviation of 18.3 lbs.  Give a 90% confidence interval for the mean difference in the average weights of PLNU basketball and baseball players. Be sure to show all formulas, work and numbers used ( e.g. df & critical value) .  At the end of your work, write a one or two sentence summary in non-statistical language to describe what you have found, not how you found it. Your audience is people who have never had a statistics class.    

Given the following two relations R and S as Sets with the following records   Perform a cartesian product operation between R and S.  You have to show the final resulting relation here on canvas. Scratch papers will be collected and discarded after the exam. 

Essay Question Instructions: Make sure you show all work on the five essay questions on scratch paper. Upload a PDF of your written work to the Canvas Upload module immediately after you finish the test. Most of the points are awarded based on your written work, not the final answer that you submit to each question. Essay Question 2: The PLNU is trying to determine if basketball players weigh more that baseball players.  A random sample was taken of  43 basketball players and their mean weight was 196 lbs with a standard deviation of 21.4 lbs.  A random sample of  59 baseball players was taken and their mean weight was 187 lbs with a standard deviation of 16.8 lbs.  Give a 95% confidence interval for the mean difference in the average weights of PLNU basketball and baseball players. Be sure to show all formulas, work and numbers used ( e.g. df & critical value) .  At the end of your work, write a one or two sentence summary in non-statistical language to describe what you have found, not how you found it. Your audience is people who have never had a statistics class.    

Select all the statements that are False.

Essay Question Instructions: Make sure you show all work on the five essay questions on scratch paper. Upload a PDF of your written work to the Canvas Upload module immediately after you finish the test. Most of the points are awarded based on your written work, not the final answer that you submit to each question. Essay Question 2: The PLNU is trying to determine if basketball players weigh more that baseball players.  A random sample was taken of  43 basketball players and their mean weight was 196 lbs with a standard deviation of 21.4 lbs.  A random sample of  59 baseball players was taken and their mean weight was 187 lbs with a standard deviation of 16.8 lbs.  Give a 95% confidence interval for the mean difference in the average weights of PLNU basketball and baseball players. Be sure to show all formulas, work and numbers used ( e.g. df & critical value) .  At the end of your work, write a one or two sentence summary in non-statistical language to describe what you have found, not how you found it. Your audience is people who have never had a statistics class. The PLNU is trying to determine if basketball players weigh more than baseball players.  A random sample was taken of  53 basketball players and their mean weight was 196 lbs with a standard deviation of 21.4 lbs.  A random sample of  62 baseball players was taken and their mean weight was 187 lbs with a standard deviation of 18.3 lbs.  Give a 95% confidence interval for the mean difference in the average weights of PLNU basketball and baseball players. Be sure to show all formulas, work and numbers used ( e.g. df & critical value) .  At the end of your work, write a one or two sentence summary in non-statistical language to describe what you have found, not how you found it. Your audience is people who have never had a statistics class.    

Suppose you have a small simple random sample (assume 13 observations), the standard deviation of the population is unknown, and the histogram of your data shows obvious skewness. Which of the following is true?

Which of the following tectonic settings is the most likely to generate an explosive volcanic eruption?

Mrs. French is implementing a system to encourage “on-task” behavior when her students are doing seat work. She has a timer that “beeps” every five minutes. If, each time the timer beeps, all the students are conscientiously working, the class is given free time to play games and work at the computer the last half hour of the day. Of the following, the best description of Mrs. French’s technique would be called:

using the CPT manual, assign the appropriate code for the following Urinary case: An endoscope was passed through the urethra. The urethra was normal in appearance, as was the bladder upon examination. The cystourethroscope was then directed to the right ureter. Slight narrowing was seen in the distal third of this ureter. A double-J stent was placed in the right ureter. The left ureter was then examined and found to be normal. The stent will be removed at a later date. CPT Code