1. The dataset has a size of 786 rows and 18 columns.
2. The dataset does not have any missing values. Therefore, the percentage
of missing values is 0%. The variable with the highest and lowest missing
values is the same, ,with 0% missing values.
3. Laptop Price:
a)Range:5925 Euros b) Minimum: 174.000 Euros C) Maximum: 6099.000
Euros d) Mode: 15.60 e) First quartile: 14.000 f) Third Quartile: 15.60
Laptop Weight:
a)Range:5925 Euros
1. Minimum: 174.000 Euros C) Maximum: 6099.000 Euros
d) Mode: 15.60 e) First quartile: 14.000
2. Third Quartile: 15.60
4. The question states that laptop price is most correlated
with brand and model. It also states that laptop price is least correlated
with brand. This seems contradictory. It’s likely there is a mistake in the
question.
In reality, laptop price is likely to be most correlated with specifications
such as:
Processor type (e.g., Intel Core i3, AMD Ryzen 5)
Screen size
RAM
5. The number of levels for these variables can vary depending on the
context, but here's a breakdown:
Company: This could have a single level (if you're only
considering one company's products) or many levels (if you're
comparing products across multiple companies). There's no
inherent limit, but it's typically a relatively small number
(e.g., Apple, Dell, HP).
Product: This also depends on the context. Within a single
company, there could be many product lines
(e.g., MacBook, XPS, Spectre), and each line might have multiple
models (e.g., MacBook Air, Pro, Max). So, it could be two or more
levels.
GPU: This typically has two levels: the manufacturer
(e.g., Intel, AMD) and the specific model (e.g., RTX 3080, Radeon
RX 6800 XT).
In summary:
Company: 1 (if single company) or many (if comparing across
companies)
Product: 2 or more (typically)
GPU: 2 (manufacturer and model)
6. CPUs and GPUs are distinct variables. While both process data, CPUs
excel at general tasks with fewer cores, while GPUs have many cores
optimized for parallel processing in tasks like video editing.
7. "Term Document Matrix (TDM) size is 417 X 973 .
8. The releveant tokens by inverse document frequency are:
x1,x2,x3,x5,x6
9. I have had Samsung phones, where the screens are nice, but the
plastic bodies come apart all of the time and feel flimsy. I have had
iPhones, where the user interface is just so boring, even with all those
apps that cost you money.
10. Your Answer:
1. Battery Life
2. Power Button
3. Graphic Card
4. USB_3
5. Backlit Keyboard
11. Here's an analysis using sample reviews to demonstrate how
concordance keywords can reveal liked and disliked features:
Concordance Keywords:
1. Battery: This keyword helps identify user sentiment towards
battery life.
oLiked Feature: Long battery life (e.g., "This laptop has
a great battery life but the screen is a bit too dim.")
o Disliked Feature: Short battery life (e.g., "This camera
takes amazing pictures but the battery drains
quickly")
2. Screen: This keyword helps understand user opinions on screen
quality.
o Liked Feature: High resolution, bright display (e.g., "I
love the new design of this phone but the camera
quality is not that good. Perfect screen for watching
videos.")
o Disliked Feature: Low resolution, dim display
(e.g., "This laptop has a great battery life but
the screen is a bit too dim.")
3. Camera: This keyword reveals user perception of camera
quality.
o Liked Feature: High megapixel count, clear pictures
(e.g., "This camera takes amazing pictures but the
battery drains quickly.")
o Disliked Feature: Low megapixel count, blurry
pictures (e.g., "I love the new design of this phone but
the camera quality is not that good.")
1. 12. Types of Tokens
1st Token
Works great no problems
or dents
2. 2nd Token
1. 2nd
Token
be careful
3. 3rd Token
Token
Need touchscreen but everything else
is flawless.
4. Great Value Money
5)
Not high performance but not bad for the
price.
13. Segment 4(31.2%)
Segment 3 ( 27.1%)
Segment 1(22.2%)
Segment 2(19.5%)
14. Segment Name : Laptop Computer
Tokens: Good Warranty, Good Keyboard issues,Amazon Bought Screen
Segment name: Laptop
Tokens: Great USB machine, easy, light ,Great laptop machine
Segment name: Laptop Screen
tokens: high quality, battery life, price,light,fast
Segment name: Fast good computer laptop
Tokens: Browser support , battery life, good keyboard.
15. To determine which segment is most promising or attractive for XYZ
Inc to pursue, let's analyze the provided data. We can consider factors
such as:
1. Overall Ratings: Average review ratings for different brands
and products.
2. Volume of Reviews: The number of reviews for each brand and
product, indicating popularity or customer interest.
3. Sentiment Analysis: The tone of the reviews to gauge
customer satisfaction.
Based on the analysis of average ratings and the number of
reviews, here are some of the top segments:
1. Acer Swift 3:
Average Rating: 5.0
Review Count: 6
2. Lenovo ThinkPad X1:
Average Rating: 5.0
Review Count: 5
3. Apple MacBook 12":
Average Rating: 5.0
Review Count: 4
Recommendations for XYZ Inc:
1. Acer Swift 3:
o Why: The Acer Swift 3 has the highest number of
reviews with a perfect rating. This indicates high
customer satisfaction and a reasonably significant
sample size.
2. Lenovo ThinkPad X1:
o Why: The Lenovo ThinkPad X1 also has a perfect rating
and a decent number of reviews, suggesting it is well-
regarded among its users.
3. Apple MacBook 12":
o Why: The Apple MacBook 12" has a perfect rating with
a slightly smaller number of reviews. Apple products
generally have strong brand loyalty, which could be a
strategic segment to pursue.
o To determine which segment is most promising or
attractive for XYZ Inc to pursue, let's analyze the
provided data. We can consider factors such as:
1. Overall Ratings: Average review ratings for
different brands and products.
2. Volume of Reviews: The number of reviews
for each brand and product, indicating
popularity or customer interest.
3. Sentiment Analysis: The tone of the reviews
to gauge customer satisfaction.
Let's perform these analyses step-by-step. We'll start by
calculating the average review ratings and the number
of reviews for each brand.
Based on the analysis of average ratings and the
number of reviews, here are some of the top segments:
4. Acer Swift 3:
Average Rating: 5.0
Review Count: 6
5. Lenovo ThinkPad X1:
Average Rating: 5.0
Review Count: 5
6. Apple MacBook 12":
Average Rating: 5.0
Review Count: 4
Recommendations for XYZ Inc:
1. Acer Swift 3:
Why: The Acer Swift 3 has the highest number
of reviews with a perfect rating. This indicates
high customer satisfaction and a reasonably
significant sample size.
2. Lenovo ThinkPad X1:
Why: The Lenovo ThinkPad X1 also has a
perfect rating and a decent number of reviews,
suggesting it is well-regarded among its users.
3. Apple MacBook 12":
Why: The Apple MacBook 12" has a perfect
rating with a slightly smaller number of
reviews. Apple products generally have strong
brand loyalty, which could be a strategic
segment to pursue.
Next Steps:
11. Market Research: Conduct deeper market
research to understand customer preferences
and potential demand.
12. Competitive Analysis: Analyze competitors'
strategies in these segments to identify
opportunities for differentiation.
13. Customer Feedback: Gather more detailed
customer feedback to identify key features and
pain points.
16.
The document with the highest sentiment score in the dataset
is Document 5, which has a sentiment score of 0.93. This indicates a
very positive sentiment associated with that document.
17. The document with the lowest sentiment score in the dataset
is Document 13, which has a sentiment score of -0.3. This indicates a
negative sentiment associated with that document.
18. The top 3 sentiment bearing tokens that AFINN marks as-4 are
hell,pissed and damn, For -3 top 3 sentiments are bad,terrible,worst. for
pos_3 great,good,nice and pos_4 are amazing,awesome and fantastic.
1. 19. Mean and Standard Deviation Score: 15.02, 1.45
2. Median and Mode: 15.60,15.60
3. Range(Min,max): 17.30, 10.10
20. Average Price: 3223.5, Price Range: 5925
21. Asus tends to value making a luxury product, with a price tag to match.
It is much more common to find luxury and elegance in the selection of
Asus laptops, with higher quality screens, speakers, and chassis. However,
despite the price tag and elevated nature of these products, the hardware
inside is hit or miss Links to an external site.. Though slightly pricier than
Acer on average, the ASUS Chromebook range, ASUS Zenbook series, and
ASUS VivoBook series offer affordable options with quality features. The
ASUS Chromebook is one of the slimmest laptops on the
market Links to an external site.. Acer, on the other hand, offers
some well-priced and compelling Chromebooks, as well as
standard models Links to an external site.. In summary, while Asus
may command a premium for its luxury features, Acer provides
competitive options across different price points.
22. Missed values were dropped from the input data. The number of total
observation were 786 and Missing data rows were 0 and Mean square
error of standardised input data is 0.21859.
23. Ultrabook, Intel,Resolution like QHD, FHD, HD, Screen type like IPS and
GPU vendor like Intel and AMD
24. The spreadsheet highlights a laptop with an Intel x5-Z8350 proce
are: Asus, Mediacom,Mediacom,Vero,Vero,Lenovo
25. The important variables are Price in euros in Y variables and in X
variables are Weight in kg , Company name, Screen Type, Operation
System, Average rating.
