What is the long-term consequence of inadequate calcium inta…
Questions
Whаt is the lоng-term cоnsequence оf inаdequаte calcium intake on bone health?
Dоwnlоаd the аttаched file. Use the data tо answer the questions. Upload your responses upon completion. laptops.csv Imagine you want to analyze a laptop dataset. This dataset contains information about various laptop models, their specifications, and pricing. It includes details such as brand, display size, processor type, graphics card, storage capacity, and both the discount and list prices. Additionally, the dataset includes customer ratings for each laptop. Download the dataset from Canvas and answer the following questions: (5 pts) What is the average discount price of laptops across all brands? (5 pts) What is the correlation between discount_price and list_price across all laptops? (5 pts) Which graphics card (graphics_card) is most commonly found in the dataset? (5 pts) Group the laptops by graphics_card and find the maximum list_price for each group. Which graphics card corresponds to the highest list price? (10 pts) Create a new column called discount_percentage that calculates the percentage discount for each laptop using the formula: (list_price – discount_price)*100/list_price (10 pts) Create a histogram of the display_size column to show the distribution of laptop screen sizes. What is the most common display size in the dataset? Set appropriate title to the plot and labels to the axes. (15 pts) Create a figure with 2 subplots: one showing a histogram of discount_price and the other showing a histogram of list_price. (10 pts) Create a boxplot showing the list price distribution by brand. Which brand has the highest price range? (25 pts) Identify the most important variable using the PCA technique. Conduct your analysis on the numerical columns, ensuring you include only the columns that contain meaningful and relevant information (do not normalize the data for this question) (10 pts) Will the most important variable identified by PCA change if you normalize the data?