This quiz is part of Algoritma Academy assessment process. Congratulations on completing the Programming for Data Science and Practical Statistics course! We will conduct an assessment quiz to test the practical programming techniques that you have learned from the course. The quiz is expected to be taken in the classroom, please contact our team of instructors if you missed the chance to take it in class.
Instruction
In this quiz, we will be using a retail dataset. You can get the CSV file stored within the datainput folder under the retail.csv file. The data stored a record of transactions of a retail store specifying several variables. Please take a look at the following glossary for your reference:
Order.ID: Id of order.Order.Date: Date of order.Ship.Date: Date of shipment.Ship.Mode: Type of shipment.Customer.ID: Id of customer.Segment : Customer's segment.Product.ID: Id of product.Category : Product category with 3 levels ("Furniture", "Office Supplies", "Technology") Sub.Category: more specific product categoryProduct.Name: Name of product that was sold.Sales: How much earning from each sale.Quantity: Quantity of item sold.Discount: How much discount was given for each sale.Profit: How much can a company earn from each sale.
We will split this quiz into 2 main sections: Programming for Data Dcience and Practical Statistics, each assessing the respective knowledge we have learned in the 2 courses.
Programming for Data Science
Among the records, there were several transactions that were sold with a quantity of more than 5. However, we are more interested in finding out how many transactions that generate above-average profit but were sold with a quantity of lesser than 5. Use a conditional subsetting to find out the number of transactions with the given conditions!
- [ ] 1380
- [ ] 1793
- [ ] 2551
- [ ] 758
If you take a look at the Ship.Mode column, you will see there are several types of shipping mode. Among all customer segments, which segment made up most of the first-class shipment?
- [ ] Consumer
- [ ] Corporate
- [ ] Home Office
If we are to analyze the subcategories within the Office Supplies category, which are the 3 most popular subcategories, taking into account the total quantity of the item sold from each subcategory?
- [ ] Binder, Paper, Storage
- [ ] Appliances, Art, Binder
- [ ] Supplies, Envelopes, Fasteners
- [ ] Paper, Binder, Art
Practical Statistics
In descriptive statistics, there are two main measurements that are commonly used to describe data distribution: central tendency and measure of spread. Which statistical measure can be used to describe the latter one?
- [ ] Probability
- [ ] Mean
- [ ] Standard Deviation
- [ ] Correlation
Find out the correlation between Sales and Profit of the transactions using the cor() function. Based on the correlation between the two, which of the following statements are true?
- [ ] As the Sales increase, the Profit gained decreases
- [ ] As the Sales decreases, the Profit gained decreases
- [ ] As the Sales increase, the Profit is fixed
Consider this case: The retail company would like to apply for a promotion to increase the number of sales. Based on historical record, you know that the monthly sales population has an average of 47,858.35 with a standard deviation of 25,195 and is distributed normally. After the promotion applied for a month, the company gained a total sales of 81,777. Using 95% confidence interval, perform a significance test using the z-test to find out whether the promotion managed to significantly affects the number of sales. How would you conclude the test using the given information?
- [ ] Fail to reject the null hypothesis, the promo does not have a statistically significant impact
- [ ] Fail to reject the null hypothesis, the promo has a statistically significant impact
- [ ] Reject the null hypothesis, the promo has a statistically significant impact
- [ ] Reject the null hypothesis, the promo does not have a statistically significant impact