Test
Data Science Mid Term
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (6)
1Download and extract the lab files for this course from http://aka.ms/edx-dat101x-labs
Run correlation analysis on data
Which of the following statements are true based on the correlations you have calculated?- AThere is a moderate positive correlation between price and sales.
- BThere is a moderate negative correlation between price and sales.
- CThere is a moderate negative correlation between temperature and sales.
- DThere is a strong negative correlation between leaflet distributions and sales.
- EThere is a strong positive correlation between leaflet distributions and sales.
2Using data from Q1...
Based on the function generated by regression, what is the predicted value for sales (to the nearest whole number) when the following feature values are used:
Temperature: 80
Leaflets: 110
Price: 0.35- A192
- B199
- C203
- D222
- E229
3You write a query that returns a list of all sales employees that have taken sales orders. Employees who have not taken sales orders should not be included in the results.
Select the appropriate join type to complete the following query.
SELECT e.FirstName, e.LastName, s.Amount
FROM HumanResources.Employee AS e
________________ Sales.SalesOrder AS s ON s.SalesPersonID = e.EmployeeID;- ALeft Inner Join
- BLeft Outer Join
- COuter Join
- DInner Join
- EFull Outer Join
4The Sales.SalesOrderDetail table contains a row for every line item sold, and includes a ProductID column to identify the product that was ordered.
The Production.Product table contains a row for every product, and includes a Discontinued column where the value 1 indicates that the product has been discontinued.
What result does the following query return?
SELECT DISTINCT ProductID
FROM Sales.SalesOrderDetail
EXCEPT
SELECT ProductID
FROM Production.Product
WHERE Discontinued = 1;- AAll products that have been sold and all products that have been discontinued.
- BAll discontinued products that have been sold.
- CAll non-discontinued products that have been sold.
- DAll non-discontinued products that have never been sold.
- EAll products that have never been sold or discontinued.
5From a survey of 500 people, you estimate the proportion who support candidate A in the upcoming election to be 60%. The standard error for this estimate is 2%. From a previous forecast (not using this survey) you get a prediction that candidate A will win 51% of the vote, with the standard error of this forecast being 3% which accounts for both sampling variability and nonsampling errors.
Using Bayesian method, we are going to combine the information from the survey and the previous forecast. What should be the prior distribution?- A0 ± 0.01
- B0.5 ± 0.02
- C0.51 ± 0.03
- D0.55 ± 0.025
- E0.6 ± 0.02
6Using survey from Q5...
Using Bayesian method, the Bayesian posterior forecast combining the survey and the forecast is:- A0.538
- B0.546
- C0.564
- D0.572
- E0.582
Información
- Descripción
- Mid Term Data Science Test sobre Data Science Mid Term, creado por Tamarah Usher el 11/01/2017.
- Autor
- Tamarah Usher
- Idioma
- English
- Visitas
- 68
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test