A national retail chain exports weekly sales data from both…
A national retail chain exports weekly sales data from both its in-store and online systems. After merging the two datasets, the analyst notices that a few customer transactions are listed more than once. Which of the following is the best first step in cleaning this data before performing sales analysis by customer?
Read DetailsAn e-commerce manager wants to visualize the number of order…
An e-commerce manager wants to visualize the number of orders received each day over the last three months to evaluate trends and identify any seasonal dips or spikes. Which visualization would be the most appropriate for this purpose?
Read DetailsA marketing team is preparing a report on campaign performan…
A marketing team is preparing a report on campaign performance for customers in California. Their dataset includes customer responses from across the country. Which of the following would be the most appropriate cleaning action to take?
Read DetailsA food delivery company wants to group delivery data by city…
A food delivery company wants to group delivery data by city to evaluate performance. However, cities are listed in inconsistent formats: “San Francisco,” “san francisco,” and “SanFran.” What is the best data cleaning step before grouping by city?
Read DetailsAn HR department surveys employees on job satisfaction using…
An HR department surveys employees on job satisfaction using a 1–10 scale. They want to visualize the distribution of responses to see which ratings are most common and whether the scores are skewed. Which chart should they use?
Read DetailsConvert 1.75 lb to grams _________________ Useful Convers…
Convert 1.75 lb to grams _________________ Useful Conversions Factors and Formulas Density D = mass/volume Mass 1 lb = 16 oz = 0.4569237 kg = 453.9 g Length 1 in = 2.54 cm 1 ft = 12 in = 0.3048 m 1 mi = 1.609 km 1 km = 0.6215 mi 1 m = 0.1 dm = 0.01 cm = 0.001 mm Volume 1 mL = 1 cm3 = 0.001 L Pressure 1 atm = 760 mmHg = 760 torr = 101.325 Pa Temperature oC = 5/9 x (oF – 32oF) oF = 9/5 x (oC) + 32oF K = oC + 273.15 Mass Number (A) Mass number (A) = =atomic number (Z) + Number of neutrons (no) Molarity Molarity (M) = moles of solute/ Liters of solution Dilution M1V1 = M2V2
Read Details