Which elements contribute to the pricing of laptop computers?
Laptop computer prices can be influenced by various factors. These factors encompass the computer’s brand, the included options and add-ons in the package, as well as the amount of memory and the speed of the processor. Although less prevalent, certain customers are willing to spend extra money to acquire a computer that matches their desired aesthetic and overall design.
Make sure the dataset you want to analyze is placed in the same folder as the Rmd file.
laptop_price <- read.csv(file = "data_Set/laptop_price.csv")
laptop_price Data input is complete, let’s start analyzing the data!!
head(laptop_price)tail(laptop_price)dim(laptop_price)#> [1] 1303 13names(laptop_price)#> [1] "laptop_ID" "Company" "Product" "TypeName"
#> [5] "Inches" "ScreenResolution" "Cpu" "Ram"
#> [9] "Memory" "Gpu" "OpSys" "Weight"
#> [13] "Price_euros"From the results of the inspection conducted, it can be concluded that:
Description of columns :
laptop_ID = A unique identifier or code assigned to a
specific laptop computerCompany = The name of the company or brand that
manufactures the laptopProduct = Product name of laptop computersTypeName = The specific classification or category that
a laptop model belongs to based on its features, design, and intended
useInches = The size or diagonal measurement of the
display screen of a laptop computer, typically expressed in inchesScreenResolution =The number of pixels displayed on the
screen horizontally and verticallyCpu = CPU (Central Processing Unit), the main
processing component that performs most of the calculations and executes
instructions.Ram = RAM (Random Access Memory),the temporary storage
space that the computer uses to hold data and instructions that are
actively being used by the CPUMemory = The storage capacity or the amount of data
that can be stored and retrieved by the laptopGpu = GPU (Graphics Processing Unit) the specialized
component responsible for rendering and processing graphics and
visualsOpSys = The software that manages and controls the
computer’s hardware, software, and overall functionalityWeight = The physical mass or heaviness of the laptop
(Kg)Price_euros = The price of the laptops listed in euros
(€)str(laptop_price)#> 'data.frame': 1303 obs. of 13 variables:
#> $ laptop_ID : int 1 2 3 4 5 6 7 8 9 10 ...
#> $ Company : chr "Apple" "Apple" "HP" "Apple" ...
#> $ Product : chr "MacBook Pro" "Macbook Air" "250 G6" "MacBook Pro" ...
#> $ TypeName : chr "Ultrabook" "Ultrabook" "Notebook" "Ultrabook" ...
#> $ Inches : num 13.3 13.3 15.6 15.4 13.3 15.6 15.4 13.3 14 14 ...
#> $ ScreenResolution: chr "IPS Panel Retina Display 2560x1600" "1440x900" "Full HD 1920x1080" "IPS Panel Retina Display 2880x1800" ...
#> $ Cpu : chr "Intel Core i5 2.3GHz" "Intel Core i5 1.8GHz" "Intel Core i5 7200U 2.5GHz" "Intel Core i7 2.7GHz" ...
#> $ Ram : chr "8GB" "8GB" "8GB" "16GB" ...
#> $ Memory : chr "128GB SSD" "128GB Flash Storage" "256GB SSD" "512GB SSD" ...
#> $ Gpu : chr "Intel Iris Plus Graphics 640" "Intel HD Graphics 6000" "Intel HD Graphics 620" "AMD Radeon Pro 455" ...
#> $ OpSys : chr "macOS" "macOS" "No OS" "macOS" ...
#> $ Weight : chr "1.37kg" "1.34kg" "1.86kg" "1.83kg" ...
#> $ Price_euros : num 1340 899 575 2537 1804 ...From these results, we have found that some data types are not correct. We need to convert the data types to the appropriate ones (perform data coercion) to ensure more accurate analysis.
laptop_price$laptop_ID <- as.character(laptop_price$laptop_ID)
laptop_price$TypeName <- as.factor(laptop_price$TypeName)
str(laptop_price)#> 'data.frame': 1303 obs. of 13 variables:
#> $ laptop_ID : chr "1" "2" "3" "4" ...
#> $ Company : chr "Apple" "Apple" "HP" "Apple" ...
#> $ Product : chr "MacBook Pro" "Macbook Air" "250 G6" "MacBook Pro" ...
#> $ TypeName : Factor w/ 6 levels "2 in 1 Convertible",..: 5 5 4 5 5 4 5 5 5 5 ...
#> $ Inches : num 13.3 13.3 15.6 15.4 13.3 15.6 15.4 13.3 14 14 ...
#> $ ScreenResolution: chr "IPS Panel Retina Display 2560x1600" "1440x900" "Full HD 1920x1080" "IPS Panel Retina Display 2880x1800" ...
#> $ Cpu : chr "Intel Core i5 2.3GHz" "Intel Core i5 1.8GHz" "Intel Core i5 7200U 2.5GHz" "Intel Core i7 2.7GHz" ...
#> $ Ram : chr "8GB" "8GB" "8GB" "16GB" ...
#> $ Memory : chr "128GB SSD" "128GB Flash Storage" "256GB SSD" "512GB SSD" ...
#> $ Gpu : chr "Intel Iris Plus Graphics 640" "Intel HD Graphics 6000" "Intel HD Graphics 620" "AMD Radeon Pro 455" ...
#> $ OpSys : chr "macOS" "macOS" "No OS" "macOS" ...
#> $ Weight : chr "1.37kg" "1.34kg" "1.86kg" "1.83kg" ...
#> $ Price_euros : num 1340 899 575 2537 1804 ...anyNA(laptop_price)#> [1] FALSEcolSums(is.na(laptop_price))#> laptop_ID Company Product TypeName
#> 0 0 0 0
#> Inches ScreenResolution Cpu Ram
#> 0 0 0 0
#> Memory Gpu OpSys Weight
#> 0 0 0 0
#> Price_euros
#> 0Great, there are no missing values!!
Brief Explanation :
summary(laptop_price)#> laptop_ID Company Product
#> Length:1303 Length:1303 Length:1303
#> Class :character Class :character Class :character
#> Mode :character Mode :character Mode :character
#>
#>
#>
#> TypeName Inches ScreenResolution Cpu
#> 2 in 1 Convertible:121 Min. :10.10 Length:1303 Length:1303
#> Gaming :205 1st Qu.:14.00 Class :character Class :character
#> Netbook : 25 Median :15.60 Mode :character Mode :character
#> Notebook :727 Mean :15.02
#> Ultrabook :196 3rd Qu.:15.60
#> Workstation : 29 Max. :18.40
#> Ram Memory Gpu OpSys
#> Length:1303 Length:1303 Length:1303 Length:1303
#> Class :character Class :character Class :character Class :character
#> Mode :character Mode :character Mode :character Mode :character
#>
#>
#>
#> Weight Price_euros
#> Length:1303 Min. : 174
#> Class :character 1st Qu.: 599
#> Mode :character Median : 977
#> Mean :1124
#> 3rd Qu.:1488
#> Max. :6099Summary :
1. The most expensive laptop specifications
laptop_price[laptop_price$Price_euros == 6099,]Answer : The laptop with the most expensive specifications is the one made by Razer company, under the product name Blade Pro. This laptop falls into the gaming category with a screen size of 17.3 inches. Additionally, it features a 4K Ultra HD / Touchscreen display with a resolution of 3840x2160, an Intel Core i7 7820HK 2.9 GHz processor, 32 GB of storage capacity, and a 1 TB SSD memory. Moreover, this laptop is equipped with the Nvidia GeForce GTX 1080 graphics card, runs on the Windows 10 operating system, and weighs approximately 3.49 kg.
2. The most cheapest Laptop spesifications
laptop_price[laptop_price$Price_euros == 174,]Answer : The laptop with the cheapest specifications is the one made by Acer company, under the product name C740-C9QX (3205U/2GB/32GB/Chrome). This laptop falls into the Netbook category with an 11.6-inch screen size. Additionally, it features a screen resolution of 1366x768, an Intel Celeron Dual Core 3205U 1.5GHz processor, 2GB of storage capacity, and a 32GB SSD memory. Moreover, this laptop is equipped with Intel HD Graphics, runs on the Chrome OS operating system, and weighs approximately 1.3kg.
3. What brands sell laptops with an average selling price below Q1 (<599 euros)?
Q1 <- laptop_price[laptop_price$Price_euros <= 599,]
Q1 <- aggregate(Price_euros~Company, Q1, mean)
Q1[order(x = Q1$Price_euros, decreasing = T),]Answer : The brands or companies that sell their laptop products with an average selling price below the first quartile are Toshiba, Dell, Lenovo, HP, Asus, Acer, Chuwi, Mediacom, Samsung, and Vero
4. What brands sell laptops with an average selling price above Q3 (>1488 euros)?
Q3 <- laptop_price[laptop_price$Price_euros >1488,]
Q3 <- aggregate(Price_euros~Company, Q3, mean)
Q3[order(x = Q3$Price_euros, decreasing = T),]Answer : The brands or companies that sell their laptop products with an average selling price above the third quartile are Razer, Acer, Dell, LG, Apple, MSI, Microsoft, Lenovo, Asus, Hp, Google, Toshiba, Samsung, Huawei
5. The selling prices of laptops vary based on their typenames.
agg_data <- aggregate(Price_euros~TypeName,laptop_price,mean)
agg_data[order(x = agg_data$Price_euros, decreasing = T),]💡 Insight : Based on the typenames, laptops with typenames “Workstation” and “Gaming” are priced on average higher compared to other typenames, costing 2280.3590 euros and 1731.3806 euros respectively, or equivalent to Rp 39,900,000 and Rp 30,324,208.5 (1€ = Rp 17,500).
Analisis Laptop yang dikeluarkan oleh perusahaan Apple
apple <-laptop_price[laptop_price$Company=="Apple",]
apple6. Analysis of the average prices of laptops produced by Apple based on the product names
agg_data_apple <-aggregate(Price_euros~Product,apple,mean)
agg_data_apple[order(x = agg_data_apple$Price_euros, decreasing = T),]💡 Insight : Laptops under the Apple brand, specifically the MacBook Pro product, are priced higher compared to the other three Apple product types, amounting to 2005.513 euros, or equivalent to 35,092,597.5 Indonesian rupiahs. Additionally, it can be observed that the only category released by Apple is “Ultrabook.”
7. Analysis of the average selling prices of products manufactured by Apple, specifically the MacBook Pro, based on its RAM and Memory.
apple1 <- apple[apple$Product == "MacBook Pro",]
apple1 <- aggregate(Price_euros~Memory+Ram,apple1,mean)
apple1 <- apple1[order(x = apple1$Price_euros, decreasing = T),]
apple1💡 Insight : Based on the table above, it can be seen that Memory and RAM have a significant impact on the average selling price of MacBook Pro laptops. The higher the value of RAM and Memory, the higher the average selling price. It can be observed that the MacBook Pro laptop with 512 GB SSD Memory and 16 GB RAM is priced at 2697.725 euros.
8. Analysis of the average selling prices of products manufactured by Apple, specifically the MacBook Pro, based on its Cpu.
apple1 <- aggregate(Price_euros~Cpu,apple,mean)
apple1 <- apple1[order(x = apple1$Price_euros, decreasing = T),]
apple1💡 Insight : Based on the above table, it can be seen that the average selling price of the MacBook Pro laptop with an Intel Core i7 2.9GHz CPU is the highest compared to other CPU types. The higher the CPU, the faster the laptop’s performance in processing data, resulting in a higher price offered.
9. Analysis of the average selling prices of products manufactured by Apple, specifically the MacBook Pro, based on its Gpu.
apple1 <- aggregate(Price_euros~Gpu,apple,mean)
apple1 <- apple1[order(x = apple1$Price_euros, decreasing = T),]
apple1💡 Insight : Based on the table above, it can be seen that the average selling price of the MacBook Pro laptop with an AMD Radeon Pro 560 GPU specification is the highest compared to other GPU types..
10. Analysis of the average selling prices of products manufactured by Apple, specifically the MacBook Pro, based on its Inches.
apple1 <- aggregate(Price_euros~Inches,apple,mean)
apple1 <- apple1[order(x = apple1$Price_euros, decreasing = T),]
apple1💡 Insight : Based on the table above, it can be observed that the average selling price of the MacBook Pro laptop with a screen size of 15.4 inches is the highest compared to others. This is because laptops with larger screens require more materials and technology to produce the larger display.
11. Analysis of the average selling prices of products manufactured by Apple, specifically the MacBook Pro, based on its ScreenResolution.
apple1 <- aggregate(Price_euros~ScreenResolution ,apple,mean)
apple1 <- apple1[order(x = apple1$Price_euros, decreasing = T),]
apple1💡 Insight : Based on the table above, it can be seen that the average selling price of the MacBook Pro laptop with the ScreenResolution specification of IPS Panel Retina Display 2880x1800 is the highest compared to other ScreenResolution types. This is because higher resolution requires a higher-quality screen panel and advanced technology to provide sharper image details and more accurate colors.
12. Analysis of the average selling prices of products manufactured by Apple, specifically the MacBook Pro, based on its Weight.
apple1 <- aggregate(Price_euros~Weight ,apple,mean)
apple1 <- apple1[order(x = apple1$Price_euros, decreasing = T),]
apple1💡 Insight : Based on the table above, it can be seen that the average selling price of the MacBook Pro laptop with a weight specification of 1.83 kg is the highest compared to other weight types.
Based on the above data analysis regarding the influence of laptop specifications on their selling prices, here are some recommendations for people who want to buy a laptop:
If you have a limited budget (under 10 million Indonesian rupiah), the following brands offer laptops that meet your needs: Toshiba, Dell, Lenovo, HP, Asus, Acer, Chuwi, Mediacom, Samsung, and Vero. However, if you have an unlimited budget, the following brands are recommended: Razer, Acer, Dell, LG, Apple, MSI, Microsoft, Lenovo, Asus, HP, Google, Toshiba, Samsung, and Huawei.
RAM and Memory: For smooth multitasking and running demanding applications, a minimum of 8GB RAM is recommended. If you require more power, consider laptops with 16GB or even 32GB RAM. In terms of memory (storage), SSD (Solid State Drive) provides faster performance compared to HDD (Hard Disk Drive). Aim for at least 256GB of storage capacity, or higher depending on your needs.
Category: Determine the laptop category based on your intended usage. For general purposes like browsing, office tasks, and multimedia, a standard laptop or ultrabook would be suitable. If you need high-performance for gaming or graphic-intensive tasks, consider gaming laptops or workstations.
CPU: Intel and AMD are the leading CPU manufacturers. Look for models with Intel Core i5 or i7 processors for a balance between performance and price. If you need more power, consider CPUs with higher clock speeds or more cores.
Screen Size: Choose a screen size that suits your preference and portability needs. Laptops typically range from 13 to 17 inches. Larger screens offer more immersive viewing experiences, while smaller screens provide better portability.
GPU: If you plan to do gaming or graphic-intensive work, a dedicated GPU (Graphics Processing Unit) is essential. Nvidia GeForce and AMD Radeon are the major GPU brands. Look for models with at least GTX 1650 or RTX 2060 for gaming, and higher-end GPUs for professional graphics work.